From: | "Hiroshi Saito" <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp> |
---|---|
To: | "bh yuan" <bhyuan(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: character conversion problem about UTF-8-->SHIFT_JIS_2004 |
Date: | 2008-02-08 07:50:54 |
Message-ID: | 028501c86a27$554456f0$0301a8c0@HP22720319231 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Ooops, shortage of information..sorry.
Please see,
http://winpg.jp/~saito/pg83/HASHIGODATA/
> Hi.
>
> ----- Original Message -----
> From: "bh yuan" <bhyuan(at)gmail(dot)com>
>
>> hi
>>
>> I used Postgresql7.4.3 with php for more than 3years.
>> Now I want to change my database to Postgresql8.3.
>> But I occur such problem
>> ----------------------------------------------------------
>> ERROR: character 0xe9ab99 of encoding "UTF8" has no equivalent in "SJIS"
>> ERROR: character 0xe9ab99 of encoding "UTF8" has no equivalent in
>> "SHIFT_JIS_2004"
>> ----------------------------------------------------------
>> The database was encoded by UTF-8,
>
> It SERVER_ENCODING=UTF-8 is Ok.
>
>> to export data as .csv file,
>> I use set client_encoding='SJIS' at client.
>
> No, you should use UTF-8 of default.
>
>> When I use Postgresql7.4.3,no problem occur,
>
> It seems that it has loose check....
>
>> but after I chaged to Postgresql8.3 ,the error was occured.
>>
>> Can I ignore the error message ?
>> or any othe method to solve this problem.
>
> "0xe9ab99" which you use is famous UNICODE.
> Then, An error is right. (not SJIS)
>
> Regards,
> Hiroshi Saito
From | Date | Subject | |
---|---|---|---|
Next Message | bh yuan | 2008-02-08 09:41:28 | Re: character conversion problem about UTF-8-->SHIFT_JIS_2004 |
Previous Message | Hiroshi Saito | 2008-02-08 07:35:18 | Re: character conversion problem about UTF-8-->SHIFT_JIS_2004 |