How To Change Default Char and Collation of Table.

OVERVIEW

The default character set for MySQL at (mt) Media Temple is latin1, with a default collation of latin1_swedish_ci. This is a common type of encoding for Latin characters. You can also change the encoding. utf8 is a common character set for non-Latin characters.

To change the default character set and collation of a table including those of existing columns (note the convert to clause):

alter table convert to character set utf8 collate utf8_unicode_ci;

Behind in making the application there are constraints to the development of collation in the database. This is my experience when experiencing problems in different collation databases. Terima kasih atas jawaban di stackoverflow.  You can see the questions and answers in the following link

Source : https://mediatemple.net/community/products/dv/204403914/default-mysql-character-set-and-collation