On lör, 2012-06-16 at 16:21 +0800, Quan Zongliang wrote:
> 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.

The operating system locale determines that, so you need to look there
if you don't agree with the result.


Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:

Reply via email to