seems to be a bug pg_set_client_encoding ($db_connection, 'UNICODE'); -- doesn't work pg_query ($dbconn, "set client_encoding to 'UNICODE'"); --- does work Agri PS: Gerard Samuel, thnx a lot :-) On Tue, 21 Oct 2003 23:16:18 +0400 Agri <agri@desnol.ru> wrote: > hmm.... really... SQL_ASCII :-\ > can i change charset of a database? > > Agri > > On Tue, 21 Oct 2003 14:59:06 -0400 > Gerard Samuel <gsam@trini0.org> wrote: > > > In what character set is your database initialised as??? > > > > Agri wrote: > > > > >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. > > > > > > > > > > > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php