I don’t know enough to understand what I’m doing. I just tried the plugin by g30rg3x it works great in localhost. I didn’t know why only character set was required to be changed without allowing users to change Collation of each field in the tables.
What is Table Collation? Quoting from unicode.org it’s about
Collation. The process of ordering units of textual information. Collation is usually specific to a particular language. Also known as alphabetizing or alphabetic sorting. Unicode Technical Standard #10,