Re: Convert a latin1 db imported in utf8...
I was thinking that the way to fix it is to read the value out as binary: convert(city using binary), and then read the binary back in using utf8: convert(convert(city using binary) using utf8).
Something to be careful of is that you can end up with a situation where it looks like you have it fixed because for example web browsers guess the right encoding, but the data in the tables is still wrong. It would be a good idea to look up the correct encoding for any characters you're not sure of, and use the hex() function to confirm what exactly the tables are storing.
Subject
Views
Written By
Posted
10620
July 13, 2007 05:59AM
4226
July 13, 2007 06:05PM
4405
July 27, 2007 05:20PM
Re: Convert a latin1 db imported in utf8...
4246
July 29, 2007 06:41AM
3574
August 07, 2007 12:04PM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.