From: Richard Huxton <dev@archonet.com>
To: David B <postgresql@thegatelys.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Unicode problem inserting records - Invalid UNICODE character
Date: Fri, 12 Nov 2004 08:18:38 +0000
Message-ID: <419471DE.1030900@archonet.com> (raw)
In-Reply-To: <GOEGKICPFOPNLIEIHGFJCEDNDDAA.postgresql@thegatelys.com>
References: <GOEGKICPFOPNLIEIHGFJCEDNDDAA.postgresql@thegatelys.com>
David B wrote:
> show client_encoding gives:
> UNICODE
>
> databases reads:
> DATABASE OWNER ENCODING
OK - with the same settings here, I start psql and do:
\i unicode_import_test.txt
I get:
CREATE TABLE
t
---------
AAA
À È Ð Ø
ZZZ
(3 rows)
In case this gets garbled by my email, the middle line contains four
accented characters, with accents as follows: A` E` D- O/
Actually, this doesn't display properly in my usual terminal (konsole
under KDE) but does under xterm.
--
Richard Huxton
Archonet Ltd
Attachments:unicode_import_test.txt (text/plain, 112B) download
CREATE TABLE foo (t text);
-- DELETE FROM foo;
COPY foo FROM STDIN;
AAA
À È Ð Ø
ZZZ
\.
SELECT * FROM foo;
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 using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, postgresql@thegatelys.com
Subject: Re: Unicode problem inserting records - Invalid UNICODE character
In-Reply-To: <419471DE.1030900@archonet.com>
* 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