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 11:26:24
Message-ID: AANLkTilylfcKbNOmer0YIw6AfvFPChygPOI5y_XOfpfo@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
That might be a problem that 'ó' is not recognized as \w
Actually I do not know which class 'ó' is in. It matches:

test=# select * from texts where title ~* E'\\mmacskacic\\M';
    title     |           a_text
--------------+----------------------------
 A macskacicó | A blah blah macskacicónak.
(1 row)

As if the end-of-word is at the last 'c' . ???

If the hex. code of 'ó' is 97 (dec.151) could someone hint me how to insert
it into the expression?

On Tue, Jun 8, 2010 at 1:17 PM, Laslo Forro <getforum(at)gmail(dot)com> wrote:

> Thanks a lot, anyway!
>
>
> On Tue, Jun 8, 2010 at 12:56 PM, Thom Brown <thombrown(at)gmail(dot)com> wrote:
>
>> On 8 June 2010 11:54, Laslo Forro <getforum(at)gmail(dot)com> wrote:
>> > 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)
>> >
>>
>> Okay, I'm not sure what the problem is there then. :S  Hopefully
>> someone else can shed some light on it for you.
>>
>> Thom
>>
>
>

In response to

Responses

pgsql-novice by date

Next:From: Laslo ForroDate: 2010-06-08 11:59:27
Subject: Re: Regexp match with accented character problem
Previous:From: Laslo ForroDate: 2010-06-08 11:17:32
Subject: Re: Regexp match with accented character problem

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