I am using a database for Vietnamese language with the collation utf8_general_ci. Some characters are not correctly stored in the database (though they appear in the correct format on the website) so I want to change the collation to utf8_unicode_ci hoping it would solve the problem. How do I do that? Thanks
one of the easiest way is to define for database and table or even columns, the collation you want to use it with.
You can also change the collation for the server, database, client from your mysql configuration too.