In some situations, it may be neccesar to force MySQL server collation and character set to UTF8.
As you can’t control all scripts that are connecting to your database( for instance: mysql command line, or mysqldump)

For that , open the my.cnf file
and add the below lines:

character_set_server=utf8
skip-character-set-client-handshake

If you are interested in better performance, add the below line:

collation_server=utf8_general_ci

If you are interested in better sorting order, add the below line instead:

collation_server=utf8_unicode_ci

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>