Ð ÐÐÐ, 14.06.2004, Ð 17:25, Tom Lane ÐÐÑÐÑ: > Peter Eisentraut <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
