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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
