Thread: Access to Mysql
02-16-06, 07:28 #1Registered User
- Join Date
- Feb 2006
Unanswered: Access to Mysql
We Change our database in to Access in to Mysql. I met an one problem. i am sharing this to all members in dbforum.com. if anyone knows the answer plz mail me @
or reply to this poster...
The problem is,
we are working for gulf company. so some fileds is having a arabic words. i am trying to convert this fileds from Access to Mysql. the specific filed contains some different values like ?????????? or some machine codes
I search on the net and download some software to convert this.
i have tried one more method. i-e export that table in to csv format and then import using phpmyadmin. i met the same result.
plz help me to overcome this problem.
02-16-06, 07:36 #2Jaded Developer
Provided Answers: 59
- Join Date
- Nov 2004
- out on a limb
sounds like its a MYSQL localistion / setup issue. What character set have you defined for your MySQL server. It defaults to Swedish
you may need to consider using unicode to store your data.
Check to see if the version of MySQL supports unicode, it didn't at version 3.23.36 it is / was planned for for later releases.I'd rather be riding on the Tiger 800 or the Norton