When I look at a character map, for instance with Windows Start, Run, All Programs, Accessories, System
Tools, Character Map and a extended character set like Arial.
I see that all the accented characters (umlauts, graves, etc.) are higher that unaccented letters. I also
can see the UTF8 equivalents.
Hiroshi Inoue wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend