On Mon, Jul 09, 2007 at 09:50:42AM -0400, Tom Lane wrote: > > On Mon, Jul 09, 2007 at 04:00:01PM +0400, alexander lunyov wrote: > >> I found this bug report: > >> http://archives.postgresql.org/pgsql-bugs/2006-09/msg00065.php > >> > >> Is it about this issue? > > Yes. > > >> And will it be fixed someday? > > Likely. In the meantime lower() can come to the rescue. > > It's not nearly as easy to fix as the reporter of that bug imagines, > because we don't know the relationship between pg_wchar representation > and the wchar_t representation assumed by the <wctype.h> functions. Just to clarify: lower() on both sides of a comparison should still work as expected on multibyte encodings ? It's been suggested here before. Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346