Solved

MySQL Or ODBC configuration

Posted on 2010-11-13
4
439 Views
Last Modified: 2012-05-10
Hi:
I had have this message when I try to import a table (this table contains Arabic data) from ms access to MySQL via ODBC connection, and the other time when I try to add a row with Arabic data to the same table in MySQL side from a link in MS Access . but when I change the Arabic to English , it works good.?
please!
3.JPG
0
Comment
Question by:Mohammad Alsolaiman
  • 2
  • 2
4 Comments
 
LVL 76

Accepted Solution

by:
arnold earned 500 total points
ID: 34131065
The issue deals with the character set you defined on the mysql database/table.  The data seems  to be a UTF8.

Use the mysql migration tool.

http://dev.mysql.com/tech-resources/articles/active-grid.html
0
 

Author Closing Comment

by:Mohammad Alsolaiman
ID: 34225282
wonderful
but what is this character set?
is something related to the languages like here we use Arabic language for instance ?
0
 
LVL 76

Expert Comment

by:arnold
ID: 34226449
UTF is the universal Transformation format
http://en.wikipedia.org/wiki/UTF-8


each language group arabic, chinese, cyrilic,eastern european, greek, hebrew, hindi, korean, japanese, etc. have a range within the UTF map where these characters are defined.
Such that instead of limiting the character sets that can be used to a specific one i.e. latin1, koi8-*,iso8859-x that matches the specific language, the UTF has all those character sets represented.UTF+060c starts the arabic punctuation and characters.

Open your windows character map, (start\accessories\system tools\character map) select the character set Unicode and then navigate through the definition of the font where you should reach the grouping of languages of interest to you.)
0
 

Author Comment

by:Mohammad Alsolaiman
ID: 34228756
thank u very much Mr, arnold
I really appreciate it
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
This Micro Tutorial will demonstrate how nuggets on the Web are formatted by using Chrome Developer Tools. These tools would not only view the site's CSS but it can also modify it and save the CSS to use on your own site.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now