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
