Thomas Kellerer <[email protected]> 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.
regards, tom lane
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
