The problem statement of converting latin 1 encoding to UTF-8 encoding in mysql  database is something similar to upgrading your linguistic skills from english to any other language in the world. Sounds impractical!! Correct, you may find it difficult to learn all the languages in the world as it is practically impossible to learn the rules of so many languages. But machines can do it easily. You just need to feed it with character set of that language and rules i.e. in technical term collation. We at naukrigulf deal with middle east countries so our system needs to understand ARABIC... Read More