Postgres Pro
Downloads
Home   >   mailing lists

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 AANLkTinkzeN3iaQ69ts_sWeQaxA1DvkVLkHeacOEo6B6@mail.gmail.com
Whole thread Raw
In response to Re: Regexp match with accented character problem  (Thom Brown <thombrown@gmail.com>)
Responses Re: Regexp match with accented character problem
List pgsql-novice
Tree view
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@gmail.com> wrote:
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

pgsql-novice by date:

Previous
From: Thom Brown
Date:
Subject: Re: Regexp match with accented character problem
Next
From: Thom Brown
Date:
Subject: Re: Regexp match with accented character problem