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: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])