Re: Postgres Encoding conversion problem - Mailing list pgsql-general

From Albe Laurenz
Subject Re: Postgres Encoding conversion problem
Date
Msg-id D960CB61B694CF459DCFB4B0128514C202043976@exadv11.host.magwien.gv.at
Whole thread Raw
In response to Re: Postgres Encoding conversion problem  (Michael Fuhr <mike@fuhr.org>)
Responses Re: Postgres Encoding conversion problem  (Clemens Schwaighofer <cs@tequila.co.jp>)
List pgsql-general
Michael Fuhr wrote:
>>> I sometimes have a problem with conversion of encodings eg from UTF-8
>>> tio ShiftJIS:
>>>
>>> ERROR:  character 0xf0a0aeb7 of encoding "UTF8" has no
>>> equivalent in "SJIS"
>>>
>>> I have no idea what character this is, I cannot view it in my
>>> browser, etc.
>>
>> It translates to Unicode 10BB7, which is not defined.
>
> Actually it's <U+20BB7 CJK UNIFIED IDEOGRAPH-20BB7>.

Oops, you're correct. Made an error in my calculations. Thanks.

So that explains the problem.
Still, to handle it, the offending character needs to be changed before
converting to SJIS.

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Postgres Encoding conversion problem
Next
From: Clemens Schwaighofer
Date:
Subject: Re: Postgres Encoding conversion problem