> >>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?
> sure, that is the same, but the result is 0 lines for both. :-)
It's ok result. I see no 'ö' in data you have posted. I see only
> we don't need two drivers anymore. Thanks a lot for your work. So far
It's not my work. I only fixed 08.01 branch since 08.01.0102.
The enahnced branch is Hiroshi (Inoue and Saito) work.
> PostgreSQL 8.0X on Debian Sarge
> Unicode or LATIN1 or SQL-ASCII Database
You tried this all?
I think it could be the problem. You have unicode data but you try
sort it in de_DE.ISO-8859-1.
Could you try change the locale for _backend_ process to de_DE.UTF-8 or
de_DE(dot)UTF-8(at)euro? (Maybe also in postmaster.conf configuration file
of postgresql). I'm not sure if it isn't even initdb time related.
> de_DE.ISO-8859-1 (default)
> 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.
I don't speak about psql (client or driver) locale. I speak about
backend locale (and settings in postmaster.conf).
The sort operation is performed in backend process.
I suggest to try ask for this (with psql client problem) in pgsql-general.
In response to
pgsql-odbc by date
|Next:||From: Luiz K. Matsumura||Date: 2006-03-29 15:37:47|
|Subject: Odbc bug ?|
|Previous:||From: Dave Page||Date: 2006-03-29 15:34:52|
|Subject: Re: psqlODBC-Driver Test / text fields|