On 22 November 2010 19:36, Tom Lane <tgl@sss.pgh.pa.us> 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