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:
If you are interested in better performance, add the below line:
If you are interested in better sorting order, add the below line instead: