Re: character conversion problem about UTF-8-->SHIFT_JIS_2004

Hi.

----- Original Message -----
From: "bh yuan" <bhyuan@gmail.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