Обсуждение: PostgreSQL 7, FreeBSD and locale support

Поиск
Список
Период
Сортировка

PostgreSQL 7, FreeBSD and locale support

От
Dmitry Morozovsky
Дата:
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 ***
------------------------------------------------------------------------

Re: PostgreSQL 7, FreeBSD and locale support

От
Oleg Bartunov
Дата:
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

Re: PostgreSQL 7, FreeBSD and locale support

От
Dmitry Morozovsky
Дата:
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 ***
------------------------------------------------------------------------