Archibald Zimonyi <arsi@xxxxxxxxxxxxxx> writes: > I went into the generated dump file and (more wish then anything else) > tried to simply change the encoding from LATIN1 to UTF8 and then load the > file, it did not complain about incorrect encoding setting for the load, > however it complained that the characters did not match true UTF8 > characters (which was almost what I guessed would happen). Indeed. Do *not* change the client_encoding setting in the dump file. You can edit the ENCODING options in the CREATE DATABASE commands though. (Didn't we explain this to you already?) regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general