Re: Regexp match with accented character problem - Mailing list pgsql-novice

From Laslo Forro
Subject Re: Regexp match with accented character problem
Date
Msg-id AANLkTik46ckX9xWckS9aVu4ZyOh5eV4g9ss94E-bXOYO@mail.gmail.com
Whole thread Raw
In response to Re: Regexp match with accented character problem  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Deborah Fuentes
Date:
Subject: CPU usage when building a schema
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] libpython - cannot open shared object file