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

From: "Huang, Suya" <Suya(dot)Huang(at)au(dot)experian(dot)com>
To: John R Pierce <pierce(at)hogranch(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: [ADMIN] what's the efficient/safest way to convert database character set ?
Date: 2013-10-20 23:10:20
Message-ID: D83E55F5F4D99B4A9B4C4E259E6227CD9DF7B4@AUX1EXC01.apac.experian.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2013-10-21 01:19:10 Re: [ADMIN] what's the efficient/safest way to convert database character set ?
Previous Message Tom Lane 2013-10-20 21:24:53 Re: Preserving the source code of views