Re: Postgres Encoding conversion problem

From: Clemens Schwaighofer <cs(at)tequila(dot)co(dot)jp>
To: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgres Encoding conversion problem
Date: 2008-04-23 00:01:40
Message-ID: 480E7C64.3060503@tequila.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 04/22/2008 07:30 PM, Albe Laurenz wrote:
> Clemens Schwaighofer 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.
>>> I guess that is not intended; can you guess what the character(s) should be?
>> to be honest no idea. its some chinese character, I have no idea how the
>> user input this, because this is a japanese page.
>>
>> I actually found the carachter, but only my Mac OS X can show it. It
>> looks similar to a japanese character used for a name, but how the
>> chinese one got selected is a mystery to me ...
>
> Are you sure that your Mac OS X computer interprets the character as
> UTF-8?

That I cannot be sure, I just searched through a page that has a
complete list. OS X can render it, Linux cannot, I have not tried windows.

--
[ 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 ]

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Wilson 2008-04-23 00:18:17 Re: Rapidly decaying performance repopulating a large table
Previous Message Klint Gore 2008-04-22 23:49:17 Re: FW: Re: create temp in function