The following bug has been logged online: Bug reference: 3525 Logged by: Rolandas Rudomanskis Email address: [EMAIL PROTECTED] 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 + "';" ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings