Postgres Pro
Downloads
Home   >   mailing lists

Re: \w doesn't match non-ASCII letters - Mailing list pgsql-bugs

From Tom Lane
Subject Re: \w doesn't match non-ASCII letters
Date
Msg-id 465.1087226747@sss.pgh.pa.us
Whole thread Raw
In response to Re: \w doesn't match non-ASCII letters  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: \w doesn't match non-ASCII letters
List pgsql-bugs
Tree view 
Peter Eisentraut <peter_e@gmx.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.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: \w doesn't match non-ASCII letters
Next
From: Bruno Wolff III
Date:
Subject: Re: inserting lots of values into a column that has "unique" property