Re: Postgres Encoding conversion problem

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "Clemens Schwaighofer *EXTERN*" <cs(at)tequila(dot)co(dot)jp>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postgres Encoding conversion problem
Date: 2008-04-22 10:30:12
Message-ID: D960CB61B694CF459DCFB4B0128514C202043714@exadv11.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2008-04-22 10:41:08 How is statement level read consistency implemented?
Previous Message D. Dante Lorenso 2008-04-22 10:01:41 How to modify ENUM datatypes?