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