Hi there,

I have a database in which all the columns have collation as utf8_general_ci.

Previously I was connecting to the database and inserting data without using SET names utf8, therefore a lot of the data has been inserted with the wrong encoding.

The problem is all the data before using that has been stored incorrectly, and wierd characters are displayed instead.

How can I convert that data into utf8? I think it must be mixed now, as I changed it to use set names utf8 so some data is correct.

Thanks

I can get access to a shell, but how do I dump it from phpmyadmin first?

I'm not sure how you'd do the phpmyadmin thing with the additional arguments; I don't use phpmyadmin that much. Sorry...