PostgreSQL 7, FreeBSD and locale support - Mailing list pgsql-admin

From Dmitry Morozovsky
Subject PostgreSQL 7, FreeBSD and locale support
Date
Msg-id Pine.BSF.4.21.0101282041120.49800-100000@woozle.rinet.ru
Whole thread Raw
Responses Re: PostgreSQL 7, FreeBSD and locale support
List pgsql-admin
Hello there,

I have configured and installed PostgreSQL 7.0.3 on a FreeBSD-4-stable
box. Configure has been run as

./configure  --enable-locale --enable-recode

However, trying every combinations of LANG env vars for both server and
client I gave standard ASCII order as a result of any SELECT ... ORDER BY
(test/locale/koi8-r as an example). One of my friends tell me that FreeBSD
has stricter than e.g. Linux locale policy, and do not treat negative
chars (and cyrillic characters are all above 0x80, so they are negative in
signed char representation).

Is there a way to get working server on FreeBSD with locale support?

Thanks in advance.

Sincerely,
D.Marck                                   [DM5020, DM268-RIPE, DM3-RIPN]
------------------------------------------------------------------------
*** Dmitry Morozovsky --- D.Marck --- Wild Woozle --- marck@rinet.ru ***
------------------------------------------------------------------------


pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: postgres limitation
Next
From: Ken Kinder
Date:
Subject: Data now showing up