MySQL, ODBC driver Access collation problem

开发者_开发技巧

I have a web aplication with an MySQL database (Collation Latin-1) and everything works fine, but when I connect to the MySQL database through Mysql connector ODBC in MS Access the data it´s not displayed correctly when everything works perfectly on web based system.

Does anybody know how to fix it?

---

make it UTF-8 and the problem will be solved