Received: from www.inreko.ee (www.inreko.ee [195.222.18.2]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9SFxrP60467 for ; Sun, 28 Oct 2001 10:59:53 -0500 (EST) (envelope-from marko@l-t.ee) Received: from grue ([195.222.18.13] helo=grue.l-t.ee) by www.inreko.ee with esmtp (Exim 3.22 #1) id 15xsU3-0003Hv-00; Sun, 28 Oct 2001 18:08:23 +0200 Received: from marko by grue.l-t.ee with local (Exim 3.32 #1 (Debian)) id 15xsLs-0005eH-00; Sun, 28 Oct 2001 17:59:56 +0200 Date: Sun, 28 Oct 2001 17:59:56 +0200 From: Marko Kreen To: Jean-Michel POURE Cc: pgsql-hackers@postgresql.org Subject: Re: UNICODE Message-ID: <20011028175956.A21552@l-t.ee> References: <4.2.0.58.20011028140833.00d13490@pop.freesurf.fr> <4.2.0.58.20011028121057.00d1a100@pop.freesurf.fr> <4.2.0.58.20011028085953.00cfa740@pop.freesurf.fr> <4.2.0.58.20011028085953.00cfa740@pop.freesurf.fr> <4.2.0.58.20011028121057.00d1a100@pop.freesurf.fr> <4.2.0.58.20011028140833.00d13490@pop.freesurf.fr> <4.2.0.58.20011028163302.00cdc890@pop.freesurf.fr> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <4.2.0.58.20011028163302.00cdc890@pop.freesurf.fr> X-Archive-Number: 200110/991 X-Sequence-Number: 14713 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