Re: Unicode problem inserting records - Invalid UNICODE character

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
CREATE TABLE foo (t text);

-- DELETE FROM foo;

COPY foo FROM STDIN;
AAA
À È Ð Ø
ZZZ
\.

SELECT * FROM foo;