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

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [ADMIN] what's the efficient/safest way to convert database character set ?
Date: 2013-10-21 01:19:10
Message-ID: 5264810E.2090801@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 10/20/2013 4:10 PM, Huang, Suya wrote:
> uestion, if the data stored in database including UTF-8 and ISO 8859-1, is that OK to dump them all in ISO-8859-1?

absolutely not. UTF8 is not valid ISO88591, and if interpreted as such
will result in garbage characters.

if you have mixed character encodings in your database, you've got some
issues trying to sort that all out to be consistent.

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Brian Crowell 2013-10-21 02:35:00 Re: Preserving the source code of views
Previous Message Huang, Suya 2013-10-20 23:10:20 Re: [ADMIN] what's the efficient/safest way to convert database character set ?