Re: a strange order by behavior

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: a strange order by behavior
Дата
Msg-id BANLkTi==wV_a5frBLPtTdGn9q1XW07HxOQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: a strange order by behavior  (Samuel Gendler <sgendler@ideasculptor.com>)
Ответы Re: a strange order by behavior  (Samuel Gendler <sgendler@ideasculptor.com>)
Список pgsql-sql
Hello Peter


> Pavel suggested using a collation of ucs_basic, but I get an error when I
> try that on linux:
> $ createdb -U u1 --lc-collate=ucs_basic -E UTF-8 test
> createdb: database creation failed: ERROR:  invalid locale name ucs_basic

isn't this a bug in collations?

Regards

Pavel

> I was able to create the db with --lc_collate=C and get case-sensitive
> sorting that treats spaces 'correctly,' but I have no idea how reliable that
> is with multibyte characters and it almost certainly doesn't handle accented


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

Предыдущее
От: Samuel Gendler
Дата:
Сообщение: Re: a strange order by behavior
Следующее
От: Samuel Gendler
Дата:
Сообщение: Re: a strange order by behavior