Re: order by different on mac vs linux
От | Peter Eisentraut |
---|---|
Тема | Re: order by different on mac vs linux |
Дата | |
Msg-id | 1338493959.22408.27.camel@vanquo.pezone.net обсуждение исходный текст |
Ответ на | Re: order by different on mac vs linux (Wes James <comptekki@gmail.com>) |
Список | pgsql-sql |
On lör, 2012-05-26 at 21:47 -0600, Wes James wrote: > on the ascii table here: > > http://www.ascii-code.com/ > > upper case letters should sort before lowercase letters. ASCII has nothing to do with how letters "should" be sorted. It is not a sorting standard, it is a character encoding standard. If you open a dictionary, you won't (usually) find all upper case letters before all lower case letters. The sort orders provided by glibc are, individual bugs aside, correct, where "correct" means, they implement various national and international standards. (Equally, the sort orders on Mac OS X are, degenerate cases aside, broken, because they don't implement any recognized sorting standard.) Of course, you are not required to like them, and there are many people who have particular issues with them, but you won't get far claiming they are wrong, if you don't have a recognized alternative source to point to that defines correctness.
В списке pgsql-sql по дате отправления: