Skip site navigation (1) Skip section navigation (2)

Re: Regexp match with accented character problem

From: Laslo Forro <getforum(at)gmail(dot)com>
To: Thom Brown <thombrown(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Regexp match with accented character problem
Date: 2010-06-08 10:54:41
Message-ID: AANLkTinkzeN3iaQ69ts_sWeQaxA1DvkVLkHeacOEo6B6@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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
>

In response to

Responses

pgsql-novice by date

Next:From: Thom BrownDate: 2010-06-08 10:56:11
Subject: Re: Regexp match with accented character problem
Previous:From: Thom BrownDate: 2010-06-08 10:24:57
Subject: Re: Regexp match with accented character problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group