On Tue, 17 Jun 2003, Tatsuo Ishii wrote:
> > > [I assume you enable the locale support.]
> >
> > isn't it enabled by default ?
>
> It can be off by using ---no-locale option with initdb.
>
what's the benefit of this for non-ascii world :?
> > > Dont't ask me. These are locale support problems.
> >
> > Sorry, I just wanted to understand where I get confused.
> > You're right, utf8 locale support in glibc is broke,
> > I've tested simple C-program with glibc 2.2.5 and 2.3.1 on
> > Linux system and toupper, tolower functions are broken.
> >
> > btw, did you try libutf8 library ?
> > http://www.haible.de/bruno/packages-libutf8.html
>
> No. BTW, upper() will never work even glibc works fine with UTF-8. See
> the code fragment below(utils/adt/oracle_compat.c);
>
> char *ptr;
> :
> :
> while (m-- > 0)
> {
> *ptr = toupper((unsigned char) *ptr);
> ptr++;
> }
>
> Apparently this is not multibyte aware...
I see. Hope someone is aware on making postgresql unicode compatible.
> --
> Tatsuo Ishii
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
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
