Mysql:- Modify Character Set

Alter Character Set in Mysql
#########################
we can convert the default encoding of the database and tables using the following commands in MySQL 4.1.

ALTER DATABASE database CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE {each table name} CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;