Results 1 to 2 of 2

Thread: Access to Mysql

  1. #1
    Join Date
    Feb 2006
    Posts
    1

    Lightbulb 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 @
    inigonirmal@rhytha.com
    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.
    with regards,
    Inigo Nirmal.N

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •