Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

Next:From: Ken KinderDate: 2001-01-28 18:15:59
Subject: Data now showing up
Previous:From: Bruce MomjianDate: 2001-01-28 17:41:28
Subject: Re: postgres limitation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group