Web Hosting Talk







View Full Version : Access -> MySQL migration = (question marks)???


jpetrov
08-19-2005, 09:54 PM
the exact result of any kind of migration done both by mysql and navicat tools has been only rows of ?????????????? in the data table. The source and destination files are utf-8 (double checked this one) as well - the correct my.ini and page encoding are all set to utf...

But still I get ??? - even before actual sql insert - I make the migration tool to export the sql inserts and these inserts also are made of question marks...

Any ideas?

azizny
08-20-2005, 05:01 PM
Is it any other languages than english?

Peace,

PerfTuner
08-20-2005, 08:29 PM
There's something wrong with your migration tool. What you need first is to make it export properly encoded SQL inserts. As a last resort, export data from each table into a tab-delimited plain text file, recreate table structure in MySQL database manually, and import data using 'load data infile' queries.
Also, check user comments on following page:
http://dev.mysql.com/doc/mysql/en/load-data.html