Thomas Kellerer <spam_eater@xxxxxxx> 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 (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
