Postgres Pro
Downloads
Home   >   mailing lists

BUG #3525: Lithuanian characters doesn't work in queries with regular expressions - Mailing list pgsql-bugs

From Rolandas Rudomanskis
Subject BUG #3525: Lithuanian characters doesn't work in queries with regular expressions
Date
Msg-id 200708091653.l79GrFGZ091419@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #3525: Lithuanian characters doesn't work in queries with regular expressions
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      3525
Logged by:          Rolandas Rudomanskis
Email address:      rolandasr@gmail.com
PostgreSQL version: 8.2.3
Operating system:   Debian Etch
Description:        Lithuanian characters doesn't work in queries with
regular expressions
Details:

The database is set to unicode. Debian locale is utf-8.

All lithuanian characters characters, except ė, ų, namely,
ą, č, ę, į, š, ū, ž in non-case sensitive queries specifying word
beginning, are ignored. SQL example:

select * from table1 where title ~* '\\m" + mytext + "';"

pgsql-bugs by date:

Previous
From: "Julian"
Date:
Subject: BUG #3523: plpython crash
Next
From: "Peter Koczan"
Date:
Subject: Re: BUG #3504: Some listening sessions never return from writing, problems ensue