Search Postgresql Archives

Re: Postgres Encoding conversion problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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                                   ]


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux