В Пнд, 14.06.2004, в 17:25, Tom Lane пишет:
> Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> > Markus Bertheau wrote:
> >> oocms=# select 'ф' ~ '^\\w$';
> >> ?column?
> >> ----------
> >> f
> >> (1 запись)
>
> > What locale are you using for LC_COLLATE? If it's C or POSIX, you need
> > to change it and re-initdb.
>
> Another likely cause of trouble is that the regexp character
> classification stuff is presently based on <ctype.h> functions and thus
> cannot work in multibyte encodings.
This is in a UTF-8 database, so yes, these are multibyte characters. Is
there something planned to support UTF-8 in regexps?
--
Markus Bertheau <twanger(at)bluetwanger(dot)de>