Migrate a MySQL Database Preserving Special Characters
TomSlick writes "Michael Chu's blog provides a good solution for people migrating their MySQL databases and finding that special characters (like smart quotes) get mangled. He presents two practical solutions to migrating the database properly."
You don't fall into the trap of using Access. Access is a nice single user database, but that is all.