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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Thom Brown | 2010-06-08 10:56:11 | Re: Regexp match with accented character problem |
Previous Message | Thom Brown | 2010-06-08 10:24:57 | Re: Regexp match with accented character problem |