Re: psqlODBC-Driver Test / text fields

Поиск
Список
Период
Сортировка
От Johann Zuschlag
Тема Re: psqlODBC-Driver Test / text fields
Дата
Msg-id 442AA3E6.8070908@online.de
обсуждение исходный текст
Ответ на Re: psqlODBC-Driver Test / text fields  (Ludek Finstrle <luf@pzkagis.cz>)
Ответы Re: psqlODBC-Driver Test / text fields  (Ludek Finstrle <luf@pzkagis.cz>)
Список pgsql-odbc
Ludek Finstrle schrieb:
>> The last query is equivalent with:
>> select name from kunde where name = 'ö'
>>
>> So I'm not surprised with the result ;-)
>>
>> What is the locale for backend? Isn't this the real problem?
>>
Hi Luf,

sure, that is the same, but the result is 0 lines for both. :-)

test-latin1=# select name from kunde where name = 'ö';
 name
------
(0 Zeilen)

the psql driver is definitely better than ever. In my (humble) opinion
we don't need two drivers anymore. Thanks a lot for your work. So far
all my tests with UNICODE, LATIN1 and SQL-ASCII databases seem to work
with the new 7.02.260 driver on Win XP, (i.e. insert, update, select)

My set-up is:

PostgreSQL 8.0X on Debian Sarge
Unicode or LATIN1 or SQL-ASCII Database

locale=de_DE

de_DE.ISO-8859-1 (default)
de_DE.UTF-8
de_DE.UTF-8@euro
de_DE.ISO-8859-15@euro

changing to de_DE didn't change anything, client_encoding didn't help,
since the problem doesn't seem to be related to the driver.

Hiroshi tracked down the problem by doing the same query with the
psql.-client. So you may be right that this an old problem.

regards,
Johann


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

Предыдущее
От: "Dave Page"
Дата:
Сообщение: Re: psqlODBC-Driver Test / text fields
Следующее
От: Ludek Finstrle
Дата:
Сообщение: Re: psqlODBC-Driver Test / text fields