At 17:09 28/10/01 +0200, you wrote:
>On Sun, Oct 28, 2001 at 02:34:49PM +0100, Jean-Michel POURE wrote:
> >
> > >psql uses your input literally - so is your console/xterm in
> > >UNICODE/UTF8?
> > Client: \encoding returns 'UNICODE'.
> > Server: \list show databases. All databases are UNICODE (except TEMPLATE0
> > and TEMPLATE1 which are ASCII of course). I use a Mandrake 8.1
> distribution
> > and think my console is UNICODE.
>
>You think? Try this:
>
> $ echo "accepté" | od -c
>
>If your term is in utf you should get:
>
> 0000000 a c c e p t 303 251 \n
> 0000011
>
>If in iso-8859-1:
>
> 0000000 a c c e p t 351 \n
> 0000010
>
>It may be in some other 8bit encoding too, then the last number
>may be different.
It is: 0000000 a c c e p t é \n 0000010
>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.
Thank you very much for your help.
Best regards, Jean-Michel POURE