From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
---|---|
To: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Table name with umlauts |
Date: | 2010-11-22 19:10:32 |
Message-ID: | 4CEAC028.9020704@iol.ie |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 22/11/2010 19:01, Thomas Kellerer wrote:
> Tom Lane wrote on 22.11.2010 19:25:
>> Thomas Kellerer<spam_eater(at)gmx(dot)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?
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.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-11-22 19:36:43 | Re: Table name with umlauts |
Previous Message | Thomas Kellerer | 2010-11-22 19:01:04 | Re: Table name with umlauts |