On 22 November 2010 19:36, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > I had the idea that the Windows version of psql was smart enough to > set client_encoding based on the console encoding it finds itself > running under, but I might be wrong about that. Or maybe you did > something that overrode its default? Apparently not: Server [localhost]: Database [postgres]: Port [5432]: Username [postgres]: psql (8.4.5) 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=# show client_encoding; client_encoding ----------------- UTF8 (1 row) postgres=# -- Regards, Peter Geoghegan -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general