Re: confused with encodings

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: confused with encodings
Date: 2003-06-17 10:02:27
Message-ID: Pine.GSO.4.56.0306171359330.16134@ra.sai.msu.su
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2003-06-17 10:21:45 Re: [HACKERS] CVS -Tip compile issue -- FreeBSD 4.8
Previous Message Tatsuo Ishii 2003-06-17 09:43:49 Re: confused with encodings