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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general