Re: character conversion problem about UTF-8-->SHIFT_JIS_2004
От | Hiroshi Saito |
---|---|
Тема | Re: character conversion problem about UTF-8-->SHIFT_JIS_2004 |
Дата | |
Msg-id | 028501c86a27$554456f0$0301a8c0@HP22720319231 обсуждение исходный текст |
Ответ на | character conversion problem about UTF-8-->SHIFT_JIS_2004 ("bh yuan" <bhyuan@gmail.com>) |
Ответы |
Re: character conversion problem about UTF-8-->SHIFT_JIS_2004
|
Список | pgsql-general |
Ooops, shortage of information..sorry. Please see, http://winpg.jp/~saito/pg83/HASHIGODATA/ > 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
В списке pgsql-general по дате отправления: