The following bug has been logged online:
Bug reference: 3525
Logged by: Rolandas Rudomanskis
Email address: rolandasr(at)gmail(dot)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 + "';"