Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] what's the efficient/safest way to convert database character set ? - Mailing list pgsql-general

From John R Pierce
Subject Re: [ADMIN] what's the efficient/safest way to convert database character set ?
Date
Msg-id 5264810E.2090801@hogranch.com
Whole thread Raw
In response to Re: [ADMIN] what's the efficient/safest way to convert database character set ?  ("Huang, Suya" <Suya.Huang@au.experian.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Huang, Suya"
Date:
Subject: Re: [ADMIN] what's the efficient/safest way to convert database character set ?
Next
From: Brian Crowell
Date:
Subject: Re: Preserving the source code of views