I am using mysql and have some data in my application in the latin1
charset. I have a necessity to support the utf 8 charset. Now I want to
migrate the data between these two charset.
The normal way I do migration is as follows:
Taking a dump of the data with the currently running mysql
converting the necessary parameters in the mysql settings and starting
the mysql with utf8 support
droping the database.
replacing latin1 to utf 8 in the dump.sql file
loading the data back on to the mysql db.
I am fearing of a data inconsistency in the way I do....
Is the above way fool proof and will not cause any data loss or there
is a easy way to convert things to utf8 support using mysql commands
without using a dump.
Appreciate a quick response.
Thanks ,
Ranjith