Postgres Encoding conversion problem - Mailing list pgsql-general

From Clemens Schwaighofer
Subject Postgres Encoding conversion problem
Date
Msg-id 480D7059.4090001@tequila.co.jp
Whole thread Raw
Responses Re: Postgres Encoding conversion problem  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
List pgsql-general
Hi,

I sometimes have a problem with conversion of encodings eg from UTF-8
tio ShiftJIS:

ERROR:  character 0xf0a0aeb7 of encoding "UTF8" has no equivalent in "SJIS"

I have no idea what character this is, I cannot view it in my browser, etc.

If I run the conversion through PHP with mb_convert_encoding it works,
perhaps he is ignoring the character.

Is there a way to do a similar thing, like ignoring this character in
postgres too?

--
[ Clemens Schwaighofer                      -----=====:::::~ ]
[ IT Engineer/Manager, TEQUILA\ Japan IT Group               ]
[                6-17-2 Ginza Chuo-ku, Tokyo 104-8167, JAPAN ]
[ Tel: +81-(0)3-3545-7703            Fax: +81-(0)3-3545-7343 ]
[ http://www.tequila.co.jp                                   ]

pgsql-general by date:

Previous
From: Justin
Date:
Subject: Re: PostgreSQL on Vista
Next
From: "A. Kretschmer"
Date:
Subject: Re: create temp in function