so I noticed some time ago that my database was encoded as latin1_swedish_ci when it should be in utf8. I found this site detailing converting a database to utf8. I did it a little different in that I downloaded the export file from phpmyadmin to my hard drive and then did a search and replace with my text editor.
I then created a new database, uploaded and imported the modified file. Everything is looking good, when I change config.php all my entries show up and EE runs fine. However when I look at the database in phpmyadmin one setting at the bottom of the page is still latin1_swedish_ci
my host wasn’t particularly helpful (or maybe I didn’t understand their response) and I don’t know how to go about fixing this so that the entire database is in utf8. The response I got from the host is below.
Since the new mySQL version you can etc your own char encoding within the PHP code on how to write it/read it.
Unfortunately we can’t simply change the entire DB settings for just one database, as it will damage others, but you can individually set your own settings within each table for whatever encoding, since mySQL 4.1
I’ve attached a screenshot of the database with the section highlighted - the tables you see there are from a script that I’ve since deleted, but haven’t removed from the database, higher up are the EE tables.
any and all help is greatly appreciated.