On Wed, 10 Jul 2002, Stephane Bortzmeyer wrote:
> On Wed, Jul 10, 2002 at 10:24:15AM -0400,
> Andrew Sullivan <andrew@libertyrms.info> wrote
> a message of 28 lines which said:
>
> > ILIKE. (The rules are different in different locales, and I don't
> > even know how ILIKE works for non-C locales.)
>
> I've not been able to make it work. With all variables set to a French
> locale (which works fine with all the programs), PostgreSQL, with
> ILIKE or upper(), is still case-sensitive. (upper('stИphane') does not
> match STEPHANE nor STиPHANE.)
it should works ! Check if you define locale environment *just before*
starting postmaster. I've been asked many times why locale doesnt' works
here in Russia and every time there were problem with locale or startup
scripts.
>
> It does not bother me, since I'm convinced that the problem is far
> too complicated to be solved by simple case-folding rules like those of
> US-ASCII.
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
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