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;