Re: psqlODBC-Driver Test / text fields - Mailing list pgsql-odbc

Johann Zuschlag wrote:

> Hiroshi Inoue schrieb:
>
>>
>> Thanks.
>> Could you issue the following 2 queries
>>
>>  select name from kunde where name >= 'ö' order by name asc;
>>
>   name
> --------
> öä-test
> öäüÃÃ
>          ÃÃ-test
> (2 Zeilen)
>
>>  select name from kunde where name <= 'öz' order by name asc;
>>
>  name
> --------
> Hühne
> Müller
> Täst
> test
> test-2
> (5 Zeilen)


Hmm utf8 code of a-umlaut seems bigger than 'z' .

Well how is the result of the following(original ?) query
    under default encoding ?

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

regards,
Hiroshi inoue