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
