Skip site navigation (1) Skip section navigation (2)

Re: Unicode problem inserting records - Invalid UNICODE character

From: Richard Huxton <dev(at)archonet(dot)com>
To: David B <postgresql(at)thegatelys(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Unicode problem inserting records - Invalid UNICODE character
Date: 2004-11-12 08:18:38
Message-ID: 419471DE.1030900@archonet.com (view raw or flat)
Thread:
Lists: pgsql-sql
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

Attachment: unicode_import_test.txt
Description: text/plain (113 bytes)

In response to

pgsql-sql by date

Next:From: Markus SchaberDate: 2004-11-12 09:57:19
Subject: Re: Unicode problem inserting records - Invalid UNICODE
Previous:From: Thomas BergDate: 2004-11-12 03:15:21
Subject: Cascade updates wait until the end of the transaction?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group