character conversion problem about UTF-8-->SHIFT_JIS_2004

From: "bh yuan" <bhyuan(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: character conversion problem about UTF-8-->SHIFT_JIS_2004
Date: 2008-02-08 07:17:47
Message-ID: 3c7b84c00802072317k6ed61742idf733a6126ed86d8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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,
to export data as .csv file,
I use set client_encoding='SJIS' at client.
When I use Postgresql7.4.3,no problem occur,
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.

Thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hiroshi Saito 2008-02-08 07:35:18 Re: character conversion problem about UTF-8-->SHIFT_JIS_2004
Previous Message Satoru Fukushima 2008-02-08 03:37:30 Re: How can exe files such as 'pg_dump' be called from stored functions?