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
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 |
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 |