Re: How do i setup Postgre to use Norwegian sorting rules?

Поиск
Список
Период
Сортировка
От Nis Jørgensen
Тема Re: How do i setup Postgre to use Norwegian sorting rules?
Дата
Msg-id fcof96$eci$1@sea.gmane.org
обсуждение исходный текст
Ответ на How do i setup Postgre to use Norwegian sorting rules?  (Sten Daniel Soersdal <netslists@gmail.com>)
Список pgsql-novice
Sten Daniel Soersdal skrev:
>
> I've tried different settings of --locale= and --lc_collate=
> But i just can't seem to get norwegian letters to be sorted correctly.
> I've tried googling and manual reading but have had little luck in
> finding it.

So, what values did you try for --locale, and what was the output of initdb?

My guess is that initdb could not find the locale you asked for, and
fell back to the default for your box.

On my Debian system, I had to add

    no_NO UTF-8

to /etc/locale.gen and then run

    /usr/sbin/locale-gen

before running

    initdb --lc_collate=no_NO

Not sure how portable this is to other Linux distros, or other Unices.

Nis

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

Предыдущее
От: Oliver Elphick
Дата:
Сообщение: Re: copy commands and linefeeds
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Null records in pg_operator