Re: Regexp match with accented character problem

Поиск
Список
Период
Сортировка
От Laslo Forro
Тема Re: Regexp match with accented character problem
Дата
Msg-id AANLkTik46ckX9xWckS9aVu4ZyOh5eV4g9ss94E-bXOYO@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Regexp match with accented character problem  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
That is the case.
I have to move to use ISO encoding because I can not use 9.0 .
Thank you!


On Tue, Jun 8, 2010 at 3:53 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
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 по дате отправления:

Предыдущее
От: Deborah Fuentes
Дата:
Сообщение: CPU usage when building a schema
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] libpython - cannot open shared object file