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

From Clemens Schwaighofer
Subject Re: Postgres Encoding conversion problem
Date
Msg-id 480E7C64.3060503@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/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                                   ]

pgsql-general by date:

Previous
From: Klint Gore
Date:
Subject: Re: FW: Re: create temp in function
Next
From: "David Wilson"
Date:
Subject: Re: Rapidly decaying performance repopulating a large table