Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-hackers by date

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

pgsql-general by date

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

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