Change Database Characters

Change Character set

There are many way to change character set
this way is to change database character set

ALTER DATABASE dbname CHARACTER SET utf8 COLLATE utf8_general_ci;

belows sql query shows that what kind of character set mysql has

mysql> show character set;