change mysql database collation

This article is about to explain how you can manage database collation and character set of your database. If you are working on website which covers only one language which