compare lower case and upper case when encoding is utf-8

Поиск
Список
Период
Сортировка
От Quan Zongliang
Тема compare lower case and upper case when encoding is utf-8
Дата
Msg-id 4FDC41FB.7060302@gmail.com
обсуждение исходный текст
Ответы Re: compare lower case and upper case when encoding is utf-8  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-hackers
Hi hackers,

I found that lower case is less than upper case when the db is created 
with utf8.
I tried below    locale   en_US.utf8   'A'<'a'     false    locale   ja_JP.utf8   'A'<'a'     true    locale
zh_CN.utf8  'A'<'a'     false
 
Under Windows    locale   Chinese_China   'A'<'a'     false

I am not sure it is normal or not.
But in Chinese, the lower case should be greater than upper, same as 
locale C.

I made some code try to fix it.
It seems to work fine.

Quan Zongliang



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Fabien COELHO
Дата:
Сообщение: Pg default's verbosity?
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: Combine non-recursive and recursive CTEs?