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