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 ] -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general