Re: psqlODBC-Driver Test / text fields

Поиск
Список
Период
Сортировка
Искать
От
Hiroshi Inoue
Тема
Re: psqlODBC-Driver Test / text fields
Дата
Msg-id
4429586D.30303@tpf.co.jp
Ответ на
Список
Дерево обсуждения
Re: Unicode is not UTF-8. was :psqlODBC-Driver Test / text Marc Herbert <Marc.Herbert@continuent.com>
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
В списке pgsql-odbc по дате отправления
От: Johann Zuschlag
Дата:
От: Campbell, Greg
Дата:
FAQ