> test-latin1=# select name from kunde order by name asc;
> name
> --------------
> Hühne
> Müller
> Täst
> test
> test-2
> öä-test
> öäüÖÄÜß-test
> (7 Zeilen)
>
> test-latin1=# select name from kunde where name >= 'ö' and name <= 'öz'
> order by name asc;
> name
> ------
> (0 Zeilen)
>
> And please note the following:
>
> test-latin1=# select name from kunde where name >= 'ö' and name <= 'ö'
> order by name asc;
> name
> ------
> (0 Zeilen)
>
> Hmm...
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?
When you have the problem in psql client feel free to ask
in another pgsql-* mailing list. It isn't odbc related bug.
Maybe we solve your problem but maybe you get the right advice
faster in another list.
Regards,
Luf