Re: Regexp match with accented character problem

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Regexp match with accented character problem
Дата
Msg-id 3963.1276005182@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Regexp match with accented character problem  (Laslo Forro <getforum@gmail.com>)
Ответы Re: Regexp match with accented character problem  (Laslo Forro <getforum@gmail.com>)
Список pgsql-novice
Laslo Forro <getforum@gmail.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

В списке pgsql-novice по дате отправления:

Предыдущее
От: Thom Brown
Дата:
Сообщение: Re: Regexp match with accented character problem
Следующее
От: Jon Jensen
Дата:
Сообщение: Re: The Two Towers