On Tue, 2011-09-13 at 14:47 +0200, Johann Spies wrote: > Thanks Giulio and Gabriele, > > > as Giulio pointed out, it seems like the destination database is in > > LATIN1 encoding, rather than UTF8. Could you please confirm this? > > That was the case. I deleted one of the databases and recreated it with > as a UTF-8 encoded database and the import went well. > > Question: Can I change the encoding system of an existing database? If > so, how? > No, you can't. You need to create a new one with the good encoding. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin