compare lower case and upper case when encoding is utf-8 - Mailing list pgsql-hackers

From Quan Zongliang
Subject compare lower case and upper case when encoding is utf-8
Date
Msg-id 4FDC41FB.7060302@gmail.com
Whole thread Raw
Responses Re: compare lower case and upper case when encoding is utf-8  (Peter Eisentraut <peter_e@gmx.net>)
List 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 by date:

Previous
From: Fabien COELHO
Date:
Subject: Pg default's verbosity?
Next
From: Magnus Hagander
Date:
Subject: Re: Combine non-recursive and recursive CTEs?