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