Re: Order by and strings

Поиск
Список
Период
Сортировка
От Fredric Fredricson
Тема Re: Order by and strings
Дата
Msg-id 4B713724.1060601@bonetmail.com
обсуждение исходный текст
Ответ на Re: Order by and strings  (Scott Marlowe <scott.marlowe@gmail.com>)
Ответы Re: Order by and strings  (Magnus Hagander <magnus@hagander.net>)
Список pgsql-general
Scott Marlowe wrote:
On Tue, Feb 9, 2010 at 1:42 AM, Fredric Fredricson
<Fredric.Fredricson@bonetmail.com> wrote: 
I use locale en_US.UTF-8 but why this should affect how leading characters
in strings are ignored is beyond me.   
P.s. this page may shed some light on the subject:

http://en.wikipedia.org/wiki/Collation
OK, thanks. It did shed some light on the subject. Only I wonder what would happen if these sort algorithms where used on things like article numbers in the industry. That would confuse the hell out of the people there.
Alas, not my problem. I have a work around that works for my little part of the universe. At least for now.

You live, you learn.
/Fredric
Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Willy-Bas Loos
Дата:
Сообщение: logging statements from hibernate to valid SQL
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Memory Usage and OpenBSD