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

Re: UNICODE

From: Marko Kreen <marko(at)l-t(dot)ee>
To: Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: UNICODE
Date: 2001-10-28 15:59:56
Message-ID: 20011028175956.A21552@l-t.ee (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-generalpgsql-hackers
On Sun, Oct 28, 2001 at 04:37:48PM +0100, Jean-Michel POURE wrote:
> At 17:09 28/10/01 +0200, you wrote:
> >        $ echo "accepté" | od -c
> It is:
>         0000000   a   c   c  e   p   t     é \n
>         0000010

Huh.  Then try 'od -t x1'.  Also what the commend 'locale'
prints.


> >Hmm.  It may be a bug in input routines.  You give PostgreSQL a
> >1byte 'é', it expects 2 byte char and overflows somewhere.  Can
> >you reproduce it on 7.1.3?  Maybe its fixed there, I cant
> >reproduce it.
> 
> I noticed some longer routines with "é" worked without any problem.
> I cannot reproduce it as I converted my database to plain ASCII.
> Will try UNICODE on 7.2 beta when adding Japanese text to my database.

Ok.  I still suggest you try to understand what was going on,
otherwise you will be in trouble again.  The logic around
encodings will be same in 7.2.

-- 
marko


In response to

  • Re: UNICODE at 2001-10-28 15:37:48 from Jean-Michel POURE

pgsql-hackers by date

Next:From: Mike RogersDate: 2001-10-28 17:07:58
Subject: Ultimate DB Server
Previous:From: Jean-Michel POUREDate: 2001-10-28 15:37:48
Subject: Re: UNICODE

pgsql-admin by date

Next:From: Mike RogersDate: 2001-10-28 17:07:58
Subject: Ultimate DB Server
Previous:From: Jean-Michel POUREDate: 2001-10-28 15:37:48
Subject: Re: UNICODE

pgsql-general by date

Next:From: Mike RogersDate: 2001-10-28 17:07:58
Subject: Ultimate DB Server
Previous:From: Jean-Michel POUREDate: 2001-10-28 15:37:48
Subject: Re: UNICODE

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