How to set postgresql client charset using PHPs PDO layer?

Question

It seems PHP PosgreSQL PDO driver does not accept charset parameter.

This does not work (as charset is missing in doc at http://www.php.net/manual/en/ref.pdo-pgsql.connection.php):

$db = new PDO('pgsql:host=localhost;dbname=database;charset=WIN1250', 'user', 'pass');

How can I set charset witch client is using?

Yes I am. :-) At least everything works. See: postgresql.org/docs/8.3/static/multibyte.html#AEN27550 — Fanda
– Fanda, Commented Jul 13, 2013 at 7:39
Thankyou; I had no idea that PostgreSQL supported NAMES as an alias for client_encoding despite using the DB for years. Interesting. (It's a good idea to show select version() in your questions by the way). It isn't clear if your edit means that you actually found a solution to the problem or not. If you did, undelete your answer and explain it a little more. — Craig Ringer
– Craig Ringer, Commented Jul 13, 2013 at 10:11

Fanda · Accepted Answer · 2013-07-13 16:55:33Z

3

I found possibilities of how to set client charset in documentation and it seems followed query works fine:

SET NAMES 'WIN1250';

edited Jul 13, 2013 at 16:55

answered Jul 13, 2013 at 0:09

Fanda

3,8166 gold badges42 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

T I Over a year ago

Please use the edit link on your question to add additional information. The Post Answer button should be used only for complete answers to the question.

Your Common Sense Over a year ago

@TI users are entitled to answer their own questions. So, nothing wrong with this one.

Collectives™ on Stack Overflow

How to set postgresql client charset using PHPs PDO layer?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related