PostgreSQL 7, FreeBSD and locale support

From: Dmitry Morozovsky <marck(at)rinet(dot)ru>
To: pgsql-admin(at)postgresql(dot)org
Subject: PostgreSQL 7, FreeBSD and locale support
Date: 2001-01-28 17:48:04
Message-ID: Pine.BSF.4.21.0101282041120.49800-100000@woozle.rinet.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)rinet(dot)ru ***
------------------------------------------------------------------------

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ken Kinder 2001-01-28 18:15:59 Data now showing up
Previous Message Bruce Momjian 2001-01-28 17:41:28 Re: postgres limitation