On 11.02.2012 20:02, [email protected] wrote:
Using the command line, I can't change the client encoding, but I can change it using the "\encoding" command :C:\>psql --variable=ENCODING=UTF8 could not find a "psql" to execute could not find a "psql" to execute psql (9.1.2) WARNING: Console code page (850) differs from Windows code page (1252) 8-bit characters might not work correctly. See psql reference page "Notes for Windows users" for details. Type "help" for help. postgres=# \encoding WIN1252 postgres=# \echo :ENCODING WIN1252 postgres=# \encoding UTF8 postgres=# \encoding UTF8 postgres=# \echo :ENCODING UTF8 postgres=# \q
Yeah, "\set ENCODING UTF8" doesn't seem to work either. The "ENCODING" psql variable tracks changes to the server's client_encoding setting, but not vice versa. That probably should be fixed, or at least it should throw an error telling the user to use \encoding instead.
As a workaround, you can set the PGCLIENTENCODING environment variable before launching psql.
-- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com -- Sent via pgsql-bugs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
