| 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: | Whole Thread | Raw Message | 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
| 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 |