Laslo Forro <getforum(at)gmail(dot)com> writes:
> It seems that accented characters are not recognized as \w.
Just FYI, that's a known problem with the regex operators if you're
using UTF8 database encoding (or more generally, any multibyte encoding,
but UTF8 is usually the one people complain about). I don't believe
updating to 8.4 would have fixed it for you --- maybe the reason the
problem went away is you switched to a different encoding, such as one
of the LATINn family?
There is a tentative fix in 9.0, FWIW.
regards, tom lane
In response to
pgsql-novice by date
|Next:||From: Jon Jensen||Date: 2010-06-08 15:35:14|
|Subject: Re: The Two Towers|
|Previous:||From: Thom Brown||Date: 2010-06-08 13:12:57|
|Subject: Re: Regexp match with accented character problem|