Tom Lane wrote on 22.11.2010 19:25:
> Thomas Kellerer<spam_eater@gmx.net> writes:
>> I'm curious why the following is not working:
>
>> postgres=# show client_encoding;
>> client_encoding
>> -----------------
>> UTF8
>> (1 row)
>
>
>> postgres=# create table umlaut_test_ö (id integer);
>> ERROR: invalid byte sequence for encoding "UTF8": 0xf6202869
>
> 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?
I changed to "chcp 1252" before running psql (I tried several other encodings as well)
And why does the JDBC driver return this incorrectly as well?
Create table and drop table is working through JDBC, but displaying the table names does not.
Regards
Thomas