Message-ID: <419471DE.1030900@archonet.com>
Date: Fri, 12 Nov 2004 08:18:38 +0000
From: Richard Huxton <dev@archonet.com>
User-Agent: Mozilla Thunderbird 0.9 (X11/20041103)
MIME-Version: 1.0
To: David B <postgresql@thegatelys.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Unicode problem inserting records - Invalid UNICODE character
References: <GOEGKICPFOPNLIEIHGFJCEDNDDAA.postgresql@thegatelys.com>
In-Reply-To: <GOEGKICPFOPNLIEIHGFJCEDNDDAA.postgresql@thegatelys.com>
Content-Type: multipart/mixed; boundary="------------070807090602000003010105"

This is a multi-part message in MIME format.
--------------070807090602000003010105
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

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

--------------070807090602000003010105
Content-Type: text/plain;
 name="unicode_import_test.txt"
Content-Transfer-Encoding: 8bit
Content-Disposition: inline;
 filename="unicode_import_test.txt"

CREATE TABLE foo (t text);

-- DELETE FROM foo;

COPY foo FROM STDIN;
AAA
أ€ أˆ أگ أک
ZZZ
\.

SELECT * FROM foo;

--------------070807090602000003010105--