Migration greek text from MsAccess to MySQL

[Nick Papaloukas]

Hello,

I have problem with the migration from MsAccess to MySQL.

My primary database is a MsAccess XP in Windows XP machine. Recently, I create a small web site to present some of the data. The pages are built with php over MySQL database in RHEL 5 server.

When I try to update my database through MySQL Migration Toolkit, I couldn't see my data in my web pages correctly.

When I try to update my database through console with the same scripts that MySQL Migration Toolkit created:
mysql –u user –p < Creates.sql
mysql –u user –p < Inserts.sql
I can see my data correctly.

My data in Ms Access are Greek text, the default encoding in my web pages is UTF8 and the charset of the MySQL tables is UTF8.

Any suggestion, where is the problem and how can I solve it.

Thanks in advance.

Nikos