I have noticed the same BUG in 8.2.3:
The ~* operation did not match cyrillic upper and lower case letters in
utf-8 encoding.
Still the Helmar's fix solves the problem (see
http://archives.postgresql.org/pgsql-bugs/2006-01/msg00200.php ).
Is there (or is it planned) an "official" solution?
Helmar, thank you very match.
Regards, Ivan.
**
* *From*: *Helmar Spangenberg <hspangenberg ( at ) frey ( dot ) de
<mailto:hspangenberg@DOMAIN.HIDDEN>>*
* *To*: *pgsql-bugs ( at ) postgresql ( dot ) org
<mailto:pgsql-bugs@DOMAIN.HIDDEN>*
* *Subject*: *Bug concerning regular expressions and UTF-8*
* Date: Fri, 20 Jan 2006 18:03:17 +0100
http://archives.postgresql.org/pgsql-bugs/2006-01/msg00200.php