Skip site navigation (1) Skip section navigation (2)

Re: Bug #837: Unable to use LATIN9 (=ISO-8859-15) encoding

From: Steve Haslam <araqnid(at)debian(dot)org>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #837: Unable to use LATIN9 (=ISO-8859-15) encoding
Date: 2002-12-05 23:33:56
Message-ID: 20021205233356.GA8074@araqnid.ddts.net (view raw or flat)
Thread:
Lists: pgsql-bugs
On Fri, Dec 06, 2002 at 12:20:54AM +0100, Peter Eisentraut wrote:
> > >From PSQL, if I perform:
> > \encoding LATIN9
> > insert into i18ntest(id, data) values('Euro symbol', '&#164;');
> >
> > then I would expect this to insert a euro symbol into the data column
> 
> '&#164;' means '&#164;', not anything else.  Maybe you want to try '\244'
> (octal).

That was a literal character 164 that the browser seems to have munged when
uploading the form (the script is also available in raw form using the URI
at the top, http://araqnid.ddts.net/~steve/i18ntest.sql)

SRH
-- 
Steve Haslam      Reading, UK                           araqnid(at)innocent(dot)com
Debian GNU/Linux Maintainer                               araqnid(at)debian(dot)org
                     Currently for sale: http://www.arise.demon.co.uk/my_cv/
almost called it today, turned to face the void, numb with the suffering
and the question- "Why am I?"                                  [queensrÿche]

In response to

pgsql-bugs by date

Next:From: Евгений ГридасовDate: 2002-12-06 06:59:22
Subject: bug or feature?
Previous:From: Peter EisentrautDate: 2002-12-05 23:20:54
Subject: Re: Bug #837: Unable to use LATIN9 (=ISO-8859-15) encoding

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group