Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 474
  • Last Modified:

MySQL Or ODBC configuration

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
Mohammad Alsolaiman
Asked:
Mohammad Alsolaiman
  • 2
  • 2
1 Solution
 
arnoldCommented:
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
 
Mohammad Alsolaimanapplication programmerAuthor Commented:
wonderful
but what is this character set?
is something related to the languages like here we use Arabic language for instance ?
0
 
arnoldCommented:
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
 
Mohammad Alsolaimanapplication programmerAuthor Commented:
thank u very much Mr, arnold
I really appreciate it
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now