Re: Regexp match with accented character problem

test=# \l
List of databases
Name | Owner | Encoding | Collation | Ctype | Access
privileges
-----------+----------+----------+-------------+-------------+-----------------------
postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
:
postgres=CTc/postgres
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
:
postgres=CTc/postgres
test | salmonix | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
(5 rows)

On Tue, Jun 8, 2010 at 12:24 PM, Thom Brown <thombrown(at)gmail(dot)com> wrote:

> On 8 June 2010 10:57, Laslo Forro <getforum(at)gmail(dot)com> wrote:
> > Thanx for your response!
> > You write:
> >>test=# select * from texts where title ~* E'\\mmacskacicó\\M';
> >>
> >>That works for me.
> > However, it doesn't work for me (if I understand you right):
>
> I suspect your database encoding is SQL_ASCII instead of UTF8. Can
> you tell us your database encoding?
>
> Thanks
>
> Thom
>