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

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