Re: PostgreSQL 7, FreeBSD and locale support

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Dmitry Morozovsky <marck(at)rinet(dot)ru>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: PostgreSQL 7, FreeBSD and locale support
Date: 2001-01-28 19:24:18
Message-ID: Pine.GSO.4.31.0101282219300.23768-100000@ra.sai.msu.su
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Dmitry,

this is known bug fixed in current sources.
It was discussed in mailing list, briefly you have two options - either
compile sources with -funsigned-char (actually, this option is requiered only
for src/backend/regex), or use --enable-multibyte option for configure.

Oleg
On Sun, 28 Jan 2001, Dmitry Morozovsky wrote:

> 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 ***
> ------------------------------------------------------------------------
>

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Dmitry Morozovsky 2001-01-28 19:32:05 Re: PostgreSQL 7, FreeBSD and locale support
Previous Message Vince Vielhaber 2001-01-28 18:54:56 Re: [DOCS] Re: postgres limitation