Re: Postgres Encoding conversion problem

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "Michael Fuhr *EXTERN*" <mike(at)fuhr(dot)org>
Cc: "Clemens Schwaighofer *EXTERN*" <cs(at)tequila(dot)co(dot)jp>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postgres Encoding conversion problem
Date: 2008-04-23 07:33:48
Message-ID: D960CB61B694CF459DCFB4B0128514C202043976@exadv11.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Clemens Schwaighofer 2008-04-23 07:52:09 Re: Postgres Encoding conversion problem
Previous Message Michael Fuhr 2008-04-23 07:04:53 Re: Postgres Encoding conversion problem