Cacher is the code snippet organizer for pro developers

# First create a dump of your MySQL database
mysqldump -u [user] -p database_name > database_name.sql
 
# Convert the data
iconv -f iso-8859-15 -t utf8 database_name.sql > database_name_iconv.sql
 
# Import the database
mysql -u [user] -p database_name < database_name_iconv.sql
 
# If you still have some specific characters that do not display
# correctly, you can update them individually.
# This is an example of updating a single quote
UPDATE `table_name` SET `column_name` = REPLACE(column_name, '’', '&rsquo;');