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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general 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

In response to

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

Browse pgsql-admin by date

  From Date Subject
Next Message Mike Rogers 2001-10-28 17:07:58 Ultimate DB Server
Previous Message Jean-Michel POURE 2001-10-28 15:37:48 Re: UNICODE

Browse pgsql-general by date

  From Date Subject
Next Message Mike Rogers 2001-10-28 17:07:58 Ultimate DB Server
Previous Message Jean-Michel POURE 2001-10-28 15:37:48 Re: UNICODE

Browse pgsql-hackers by date

  From Date Subject
Next Message Mike Rogers 2001-10-28 17:07:58 Ultimate DB Server
Previous Message Jean-Michel POURE 2001-10-28 15:37:48 Re: UNICODE