Re: [ADMIN] what's the efficient/safest way to convert database character set ?

On 10/20/2013 3:56 AM, Huang, Suya wrote:
> 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.



--
john r pierce                                      37N 122W
somewhere on the middle of the left coast