Re: Regexp match with accented character problem

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