Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

MySQL Or ODBC configuration

Posted on 2010-11-13
4
Medium Priority
?
468 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 80

Accepted Solution

by:
arnold earned 2000 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 80

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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
When you put your credit card number into a website for an online transaction, surely you know to look for signs of a secure website such as the padlock icon in the web browser or the green address bar.  This is one way to protect yourself from oth…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

972 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