trouble with utf-8 between pgsql and php
| From: | Agri | Date: | Tue, 21 Oct 2003 18:34:37 +0000 |
| Subject: | trouble with utf-8 between pgsql and php | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-31233@lists.php.net to get a copy of this message | ||
Hello
I'm trying to modify all my php scripts to generate utf-8 output.
I got trouble with getting utf-8 encoded text from pgsql.
My database contains koi8-r encoded text.
I tried to call
pg_set_client_encoding ($db_connection, 'UNICODE');
but it didn't help, i still recieved koi8-r encoded text.
Where is the problem? Is it a bug of 'postmaster' or sql client?
Are LC_* or LANG environment vars used to configure recoding?
Agri
PS: I really don't want to recode text by php code using iconv.