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

From Clemens Schwaighofer
Subject Re: Postgres Encoding conversion problem
Date
Msg-id 480EEAA9.9090800@tequila.co.jp
Whole thread Raw
In response to Re: Postgres Encoding conversion problem  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
List pgsql-general
On 04/23/2008 04:33 PM, Albe Laurenz wrote:
> 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.

probably wont get around a clean up before writing script. *sigh* Or
export the data in UTF-8 ...

--
[ Clemens Schwaighofer                      -----=====:::::~ ]
[ IT Engineer/Manager, TEQUILA\ Japan IT Group               ]
[                6-17-2 Ginza Chuo-ku, Tokyo 104-8167, JAPAN ]
[ Tel: +81-(0)3-3545-7703            Fax: +81-(0)3-3545-7343 ]
[ http://www.tequila.co.jp                                   ]

pgsql-general by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: Postgres Encoding conversion problem
Next
From: "Vanole, Mike"
Date:
Subject: Best approach for large table maintenance