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