Link to home
Start Free TrialLog in
Avatar of Mohammad Alsolaiman
Mohammad AlsolaimanFlag for Saudi Arabia

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of arnold
arnold
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mohammad Alsolaiman

ASKER

wonderful
but what is this character set?
is something related to the languages like here we use Arabic language for instance ?
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.)
thank u very much Mr, arnold
I really appreciate it