| From: | "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "Clemens Schwaighofer *EXTERN*" <cs(at)tequila(dot)co(dot)jp>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Postgres Encoding conversion problem |
| Date: | 2008-04-22 08:37:59 |
| Message-ID: | D960CB61B694CF459DCFB4B0128514C202043649@exadv11.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Clemens Schwaighofer wrote:
> 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.
It translates to Unicode 10BB7, which is not defined.
I guess that is not intended; can you guess what the character(s) should be?
> 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?
As far as I know, no.
You'll have to fix the data before you import them.
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Clemens Schwaighofer | 2008-04-22 08:43:23 | Re: Postgres Encoding conversion problem |
| Previous Message | Justin | 2008-04-22 05:33:53 | Re: PostgreSQL on Vista |