Re: Problem with the accents

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: frederic(at)juliana-multimedia(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problem with the accents
Date: 2001-09-28 00:56:39
Message-ID: 20010928095639X.t-ishii@sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2001-09-28 01:02:12 Re: trigger compile problem
Previous Message Benjamin Franks 2001-09-28 00:51:07 Re: PostgreSQL 7.1 on SMP: FreeBSD 4.3 || Linux 2.4.x?

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2001-09-28 01:05:24 Re: multibyte performance
Previous Message Bruce Momjian 2001-09-28 00:40:17 Re: O_DIRECT and performance