Re: PostgreSQL

Well, I have no mention of this problem in the TODO list, so I would
like to get a good description of why it isn't working.

Looking at the code, I see upper() is defined in oracle_compat.c (you
would think it would be more standard), and it calls toupper(), so it
probably works on single-bytes encodings, but not multi-byte ones. Is
this correct? is there a way to do multi-byte toupper? Perhaps
converting to wide characters and calling towupper()?

---------------------------------------------------------------------------

Oleg Bartunov wrote:
> On Mon, 11 Aug 2003, Bruce Momjian wrote:
>
> >
> > Not sure. I thought it would work.
> >
>
> No, it doesn't works. Several people already complained about bad
> unicode support. I recall Tatsuo comment some piece of code.
> I have a little page http://www.sai.msu.su/~megera/postgres/utf8.html
> about my experience with UTF8 and cyrillic.
>
>
>
> > ---------------------------------------------------------------------------
> >
> > Eugeny Balakhonov wrote:
> > > Hello, all!
> > >
> > > I have a good question for PostgreSQL FAQ.
> > >
> > > How to use string functions (like UPPER()/LOWER()) for non-latin strings?
> > > Why UPPER() function doesn't work with my UNICODE PostgreSQL database which contains non-latin characters (like cyrillic)?
> > > How to make case insensetive search by text field which contains non-latin characters?
> > >
> > > Thanks for your answers!
> > >
> > > Best regards
> > > Eugeny
> >
> >
>
> 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
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073