Tagged Questions

1
vote
1answer
83 views

What is the fastest way to convert MySQL columns to UTF8 from latin1 colums who's data is actually UTF8?

I have a MySQL table that has a number of columns with the latin1 character set. Because of driver issues, the columns actually contain utf8 data. I want to leave the data as-is but change the ...
5
votes
5answers
1k views

Best way to make sure a MySQL database is fully in UTF8

After some problems with UTF8 and none-UTF8 strings, we're standardising on UTF8. One thing I need to do is check that everything is in UTF8 in the MySQL database? What do I need to check? Server ...