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. http://wiki.postgresql.org/wiki/FAQ#Why_do_my_strings_sort_incorrectly.3F -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers