Re: Postgres Encoding conversion problem

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