Re: psqlODBC-Driver Test / text fields

Johann Zuschlag wrote:

> Dave Page schrieb:
>
>> OK, that sounds like the old bug we were seeing. What is the difference
>> between those and the previous results you reported a few minutes ago?
>> Is it just the text/varchar difference?
>>
>> Regards, Dave.
>>
>>
>>
>
> Hi Dave,
>
> the problem doesn't seem to be related to the text field. Please note
> the examples below:
>
> 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