Re: Postgres Encoding conversion problem

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: Postgres Encoding conversion problem
Дата
Msg-id D960CB61B694CF459DCFB4B0128514C202043649@exadv11.host.magwien.gv.at
обсуждение исходный текст
Ответ на Postgres Encoding conversion problem  (Clemens Schwaighofer <cs@tequila.co.jp>)
Ответы Re: Postgres Encoding conversion problem  (Clemens Schwaighofer <cs@tequila.co.jp>)
Re: Postgres Encoding conversion problem  (Michael Fuhr <mike@fuhr.org>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: "A. Kretschmer"
Дата:
Сообщение: Re: create temp in function
Следующее
От: Clemens Schwaighofer
Дата:
Сообщение: Re: Postgres Encoding conversion problem