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;
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
