Search Postgresql Archives

Re: russian case-insensitive regexp search not working

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



No, ILIKE also does case-sensitive search.

I found this bug report:
http://archives.postgresql.org/pgsql-bugs/2006-09/msg00065.php

Is it about this issue? And will it be fixed someday?

Sergey Levchenko wrote:
Just use: select street from people where street ILIKE 'зелен%';

select with case-insensitive regexp does no work right now!

On 09/07/07, alexander lunyov <lan@xxxxxxxxxxxx> wrote:
Hello, friends.

OS FreeBSD 6.2, Postgresql 8.2.4

Postgresql does not search case-insensitive russian regexp unicode
patterns. Postgres is working under user pgsql with login class (in
/etc/login.conf):

postgres:\
     :lang=ru_RU.UTF-8:\
     :setenv=LC_COLLATE=C:\
     :tc=default:

In .profile of postgres user:

LANG=ru_RU.UTF-8
export LANG
CHARSET=UTF-8
export CHARSET

Then, database:

db=> \encoding
UTF8

Case insensitive search for low-cased pattern show nothing:

db=> select street from people where street ~* 'зелен';
  street
--------
(0 rows)

While there are records, but they are with first capital character:

db=> select street from people where street ~* 'Зелен';
      street
----------------
  Зеленая
  Зеленоградская
(2 rows)

Search for english values work fine, russian values not. Why could it be?

--
alexander lunyov
lan@xxxxxxxxxxxx


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster


--
alexander lunyov
lan@xxxxxxxxxxxx



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux