Re: [GENERAL] Problem with the accents

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: pgsql-hackers(at)postgresql(dot)org
Cc: frederic(at)juliana-multimedia(dot)com
Subject: Re: [GENERAL] Problem with the accents
Date: 2001-10-02 05:47:59
Message-ID: 20011002144759N.t-ishii@sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

You are definitely inputting ISO 8859-1 characters, not UTF-8. That's
the source of your problem.

> Tatsuo Ishii wrote:
> >
> > > > Are you sure that you put the query in UTF-8 encoding?
> > >
> > > Yes :
> > >
> > > essai=> SHOW CLIENT_ENCODING;
> > > NOTICE: Current client encoding is UNICODE
> > > SHOW VARIABLE
> >
> > My point is whether you put the character in UTF-8 or not. Try:
> >
> > $ echo 'e' > e.txt (e is actually e + accent)
> > $ od -x e.txt
> >
> > and show me the result of "cat e.txt"
>
>
> $ echo 'é' > e.txt
>
> $ cat e.txt
> é
>
> $ od -x e.txt
> 0000000 0ae9
> 0000002

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message 2001-10-02 06:06:27 Problem with indices (?) in PostgreSQL 7.0.2
Previous Message David L. Collison 2001-10-02 04:16:43 oleDB Support

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-10-02 05:55:45 Re: [HACKERS] CVS changes
Previous Message Sean Chittenden 2001-10-02 05:07:27 Re: cvs problem