Re: PostgreSQL 7, FreeBSD and locale support

On Sun, 28 Jan 2001, Oleg Bartunov wrote:

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

Well, I'd evaluated -funsigned-char gcc option already, but not deeply,
and was slightly frightened by rather intensive usage of 'unsigned char'
type in sources (72 .c and .h files in 7.0.3 source tree contains
declarations of that type).

Is it safe to use? ;-)

Thanks for your support.

OB>
OB>     Oleg
OB> On Sun, 28 Jan 2001, Dmitry Morozovsky wrote:
OB>
OB> > Hello there,
OB> >
OB> > I have configured and installed PostgreSQL 7.0.3 on a FreeBSD-4-stable
OB> > box. Configure has been run as
OB> >
OB> > ./configure  --enable-locale --enable-recode
OB> >
OB> > However, trying every combinations of LANG env vars for both server and
OB> > client I gave standard ASCII order as a result of any SELECT ... ORDER BY
OB> > (test/locale/koi8-r as an example). One of my friends tell me that FreeBSD
OB> > has stricter than e.g. Linux locale policy, and do not treat negative
OB> > chars (and cyrillic characters are all above 0x80, so they are negative in
OB> > signed char representation).
OB> >
OB> > Is there a way to get working server on FreeBSD with locale support?
OB> >
OB> > Thanks in advance.
OB> >
OB> > Sincerely,
OB> > D.Marck                                   [DM5020, DM268-RIPE, DM3-RIPN]
OB> > ------------------------------------------------------------------------
OB> > *** Dmitry Morozovsky --- D.Marck --- Wild Woozle --- marck@rinet.ru ***
OB> > ------------------------------------------------------------------------
OB> >
OB>
OB>     Regards,
OB>         Oleg
OB> _____________________________________________________________
OB> Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
OB> Sternberg Astronomical Institute, Moscow University (Russia)
OB> Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
OB> phone: +007(095)939-16-83, +007(095)939-23-83
OB>

Sincerely,
D.Marck                                   [DM5020, DM268-RIPE, DM3-RIPN]
------------------------------------------------------------------------
*** Dmitry Morozovsky --- D.Marck --- Wild Woozle --- marck@rinet.ru ***
------------------------------------------------------------------------