Patterns

Apply the following settings to my.cnf to use MyISAM as Storage Engine (should be the default though) and UTF8 as default character set:

[mysqld]
..
default-storage-engine = myisam
default-character-set = UTF8


Check if setting the character set worked:

mysql> SHOW VARIABLES LIKE 'character_set%';
mysql> SHOW VARIABLES LIKE 'collation%';