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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster