Postgres Encoding conversion problem

From: Clemens Schwaighofer <cs(at)tequila(dot)co(dot)jp>
To: pgsql-general(at)postgresql(dot)org
Subject: Postgres Encoding conversion problem
Date: 2008-04-22 04:58:01
Message-ID: 480D7059.4090001@tequila.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 ]

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2008-04-22 05:12:08 Re: create temp in function
Previous Message Gurjeet Singh 2008-04-22 03:27:53 Re: PostgreSQL on Vista