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@rinet.ru ***
> ------------------------------------------------------------------------
>
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83