Re: psqlODBC-Driver Test / text fields

Hiroshi Inoue schrieb:

>
>>
>> 2. Searching for a string starting with o-Umlaut (german character)
>> doesn't return any results (in my app.).
>>
>> 2006-03-27 16:50:37 [2931] LOG: statement: declare "SQL_CUR0210FD50"
>> cursor with hold for SELECT t6.* FROM KUNDE t6 WHERE t6.name >= 'ö'
>> AND t6.name <= 'öz' ORDER BY t6.name ASC, t6.kundenid ASC
>>
>> Maybe the WHERE-statement is not parsed by the driver. But the hex
>> representation of 'ö' is 'C3B6', that is the correct UTF8 code (not
>> unicode) of o-Umlaut.
>
>
> Hi Johann,
> Could you try the same query using psql with the client_encoding 'UTF8' ?
>
> regards,
> Hiroshi Inoue
>

Hi Hiroshi,

Do you mean psql on the Linux-server?

my locales:
de_DE.ISO-8859-1 (default)
de_DE.UTF-8
de_DE(dot)UTF-8(at)euro
de_DE(dot)ISO-8859-15(at)euro

I call psql:
- set client_encoding='UTF8';
- select name from kunde;
result e.g: 'öä-test' (=o-Umlaut, a-Umlaut, -test)

- select name from kunde where name >= 'ö' and name <= 'öz' order by
name asc;

result: ERROR: Unicode characters greater than or equal to 0x10000 are
not supported

export LANG=de_DE.UTF-8 doesn't change the behavior.

(select name from kunde where name >= 'ö' and name <= 'öz' order by
name asc; works of course)

regards,
Johann