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

From alexander lunyov
Subject Re: russian case-insensitive regexp search not working
Date
Msg-id 46930DB8.8080307@startatom.ru
Whole thread Raw
In response to Re: russian case-insensitive regexp search not working  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Responses Re: russian case-insensitive regexp search not working  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List pgsql-general
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@startatom.ru


pgsql-general by date:

Previous
From: "Postgres User"
Date:
Subject: Fastest way to join materalized view to child tables
Next
From: "Harpreet Dhaliwal"
Date:
Subject: Duplicate Unique Key constraint error