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

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

Reply via email to