pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Marko Kreen <marko@l-t.ee>
To: Jean-Michel POURE <jm.poure@freesurf.fr>
Cc: pgsql-hackers@postgresql.org
Subject: Re: UNICODE
Date: Sun, 28 Oct 2001 17:59:56 +0200
Message-ID: <20011028175956.A21552@l-t.ee> (raw)
In-Reply-To: <4.2.0.58.20011028163302.00cdc890@pop.freesurf.fr>
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>

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




view thread (23+ messages)  latest in thread

Message-ID: <20011028175956.A21552@l-t.ee>
Permalink:  ../20011028175956.A21552@l-t.ee/
Also on:    postgresql.org/message-id/20011028175956.A21552@l-t.ee

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: marko@l-t.ee, jm.poure@freesurf.fr, pgsql-hackers@postgresql.org
  Subject: Re: UNICODE
  In-Reply-To: <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.20011028163302.00cdc890@pop.freesurf.fr> <20011028175956.A21552@l-t.ee>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox