Re: Unicode is not UTF-8

Поиск
Список
Период
Сортировка
От Johann Zuschlag
Тема Re: Unicode is not UTF-8
Дата
Msg-id 44355682.7080406@online.de
обсуждение исходный текст
Ответ на Re: Unicode is not UTF-8. was :psqlODBC-Driver Test / text  (Hiroshi Inoue <inoue@tpf.co.jp>)
Ответы Re: Unicode is not UTF-8  (Hiroshi Inoue <inoue@tpf.co.jp>)
Список pgsql-odbc
Hiroshi Inoue schrieb:
> b) locale = de_DE.UTF-8
>>   backend-2 = Unicode
>
>
> What's the result of
>    show server_encoding
Hi Hiroshi,

when I use an unicode database it is UNICODE,
for LATIN1 it's of course LATIN1.
(and for LATIN9 it's LATIN9)

Thank you for your explanations. Now I'm understanding what is happening
with a windows client on one end and PostgreSQL on the other end.

I am just experimenting with the three above settings (initdb with
ISO8859-15, locale ISO8859-15 only). So far it seems to work pretty
well. No problems with an application using psqlodbc driver. All German
characters including euro (LATIN9, UNICODE) seem to work. Sorting is ok.
pgAdminIII is producing the same output. psql works as well, except psql
in conjunction with unicode behaves still a little bit strange. Maybe my
locale setting is not appropriate, but de_DE.UTF-8 doesn't change it.
Will check my console later.

Unfortunately I couldn't test 7.03.262 (psqlodbc35W.dll) since the zip
file has some kind of error.

Regards,
Johann


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

Предыдущее
От:
Дата:
Сообщение: [ psqlodbc-Bugs-1000605 ] Escaped single-quotes mistreated by PGAPI_NumParams
Следующее
От: Hiroshi Inoue
Дата:
Сообщение: Re: Unicode is not UTF-8