odbc silently dropping national characters in CP1250 encoding

Поиск
Список
Период
Сортировка
От Dragan Matic
Тема odbc silently dropping national characters in CP1250 encoding
Дата
Msg-id a5acdc8c0906040035t472f126fs1eaf7b43932f0783@mail.gmail.com
обсуждение исходный текст
Ответы Re: odbc silently dropping national characters in CP1250 encoding  (Hiroshi Inoue <inoue@tpf.co.jp>)
Список pgsql-odbc
I have a LATIN2 database on the server side and a Postgresql ANSI odbc
connection on the client side (windows xp sp2, latest odbc driver,
version 8.03.04.00)

when I try inserting something like this:

insert into sample_table (sample_column) values ('öüóőúíéáűÍÜÓÖŐÚÉÁŰ')
insert into sample_table (sample_column) values ('čćšđž ČĆŽŠĐ')

and then selecting it, I get the following:

öüóoúíéáuÍÜÓÖOÚÉÁU
ccšdž CCŽŠÐ


So, the characters ő,ű,Ő,Ű,č,ć,đ,Č and Ć have been silently replaced
with o,u,O,U,c,c,d,C and C

the same thing happens when database is created with WIN1250 encoding.

when I try doing the same thing from pgadminIII, everything is OK -
characters are inserted and read properly so I suppose the problem is
somewhere in the ODBC connection. Am I missing some setting or how can
I set this up properly?

Dragan Matic

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

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: ODBC driver and refcursors
Следующее
От: Hiroshi Inoue
Дата:
Сообщение: Re: odbc silently dropping national characters in CP1250 encoding