Re: russian case-insensitive regexp search not working - Mailing list pgsql-general

On Tue, Jul 10, 2007 at 08:40:24AM +0400, alexander lunyov wrote:

>> Just to clarify: lower() on both sides of a comparison
>> should still work as expected on multibyte encodings ? It's
>> been suggested here before.
>
> lower() on both sides also does not working in my case, it still search for
> case-sensitive data. String in this example have first char capitalized,
> and result is the same. Seems that lower() can't lower multibyte character.
>
> db=> select lower('Зелен');
Well, no,

    select my_string where lower(my_string) ~ lower(search_fragment);

Does that help ?

(~ does work for eg. German in my experience)

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346