0

How to change default MySQL database character set and collation

Wednesday, November 7, 2007

First of all check the different character set available using MySQL command:
mysql> show character set;

You can change the character set and collation of a database by using the following MySQL command
:
mysql> ALTER DATABASE `` DEFAULT CHARACTER SET COLLATE

Modify the , , as per the requirement.

0 Responses to "How to change default MySQL database character set and collation"