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

From: Quan Zongliang <quanzongliang(at)gmail(dot)com>
To: Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: compare lower case and upper case when encoding is utf-8
Date: 2012-06-16 08:21:15
Message-ID: 4FDC41FB.7060302@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2012-06-16 08:57:11 Re: Combine non-recursive and recursive CTEs?
Previous Message Fabien COELHO 2012-06-16 07:42:31 Pg default's verbosity?