"Raymond O'Donnell" <rod@xxxxxx> writes: > On 22/11/2010 19:01, Thomas Kellerer wrote: >> Tom Lane wrote on 22.11.2010 19:25: >>> It looks to me like your console is not in fact producing UTF8; >>> it's representing ö as 0xf6, which I think is right for Latin1. >>> Select the proper client_encoding. >> I assume you mean the encoding in the console? > No, he means the encoding on the connection: > http://www.postgresql.org/docs/9.0/static/multibyte.html#AEN30728 > ...so that the server returns the correct characters for your console. For this problem it's actually more the other way round: the characters being *sent* to the server have to be in the encoding you said they'd be in, namely client_encoding. 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? >> I changed to "chcp 1252" before running psql (I tried several other encodings as well) Try "set client_encoding = win1252", then. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
