Re: Problem with the accents - Mailing list pgsql-general

From Tatsuo Ishii
Subject Re: Problem with the accents
Date
Msg-id 20010928095639X.t-ishii@sra.co.jp
Whole thread Raw
In response to Problem with the accents  (frederic massot <frederic@juliana-multimedia.com>)
List pgsql-general
> I have a problem at the time of requete containing accents with
> PostgreSQL version 6.5.3 :
>
> Via psql, the following requete does not function :
>
> SELECT id_dico, name
>  FROM  dico_fr
>  WHERE name ~* '^bé'
>  ORDER BY name;
>
>
> The tables are coded in UNICODE.

Are you sure that you put the query in UTF-8 encoding?
--
Tatsuo Ishii

pgsql-general by date:

Previous
From: Benjamin Franks
Date:
Subject: Re: PostgreSQL 7.1 on SMP: FreeBSD 4.3 || Linux 2.4.x?
Next
From: Keary Suska
Date:
Subject: Re: temp table::persistance problem