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

On 8 June 2010 10:57, Laslo Forro <getforum@gmail.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