Re: russian case-insensitive regexp search not working

From: alexander lunyov <lan(at)startatom(dot)ru>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: russian case-insensitive regexp search not working
Date: 2007-07-10 04:40:24
Message-ID: 46930DB8.8080307@startatom.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Karsten Hilbert 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('Зелен');
lower
-------
Зелен
(1 запись)

--
alexander lunyov
lan(at)startatom(dot)ru

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Harpreet Dhaliwal 2007-07-10 05:14:08 Duplicate Unique Key constraint error
Previous Message Postgres User 2007-07-10 03:07:51 Fastest way to join materalized view to child tables

Browse pgsql-hackers by date

  From Date Subject
Next Message Neil Conway 2007-07-10 05:57:22 Re: CREATE TABLE LIKE INCLUDING INDEXES support
Previous Message Tom Lane 2007-07-10 01:44:47 Re: Weird ecpg failures on buildfarm NetBSD members