Re: UNICODE - Mailing list pgsql-hackers

From Marko Kreen
Subject Re: UNICODE
Date
Msg-id 20011028175956.A21552@l-t.ee
Whole thread Raw
In response to Re: UNICODE  (Jean-Michel POURE <jm.poure@freesurf.fr>)
List pgsql-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



pgsql-hackers by date:

Previous
From: Jean-Michel POURE
Date:
Subject: Re: UNICODE
Next
From: "Mike Rogers"
Date:
Subject: Ultimate DB Server