> We stored ISO-8859-1, do we still need to use iconv to convert the file?
you should be able to do the dump specifying pg_dump --encoding=iso-8559-1 then restore it to the utf8 database, and postgres will do the conversion for you. One more question, if the data stored in database including UTF-8 and ISO 8859-1, is that OK to dump them all in ISO-8859-1? Thanks, Suya -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
