Importing Arabic text From MS Access to MySQL

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
simjith
Forum Newbie
Posts: 4
Joined: Sat Nov 08, 2008 10:25 am

Importing Arabic text From MS Access to MySQL

Post by simjith »

Hi All,

I want to import the entire data in an MS Access Database(with some fields containing both Arabic and English Text) to MySQL.
I had Imported the entire content of the same to MySQL Database using Premiumsoft Navicat.
But when ever i tried to import mixed fields(some records contains both arabic and english data,some times any one of these

two),the english data is shown fine,
at the same time the arabic data is shown as ??????? ???????? ?? ???? ?????.
At the same time I am able to add or edit Arabic Text to the same Database

Please Help

My MySQL Version: 5.0.51b


Here is my Table Structure
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
CREATE TABLE `contacts` (
`ID` bigint(11) NOT NULL auto_increment,
`Title` varchar(255) default NULL,
`FirstName` varchar(255) default NULL,
`Company` varchar(255) default NULL,
`Department` varchar(255) default NULL,
`JobTitle` varchar(255) default NULL,
`BusinessStreet` varchar(255) default NULL,
`BusinessCity` varchar(255) default NULL,
`BusinessState` varchar(255) default NULL,
`BusinessPostalCode` varchar(255) default NULL,
`BusinessCountry` varchar(255) default NULL,
`HomeStreet` varchar(255) default NULL,
`HomeCity` varchar(255) default NULL,
`HomeState` varchar(255) default NULL,
`HomePostalCode` varchar(255) default NULL,
`HomeCountry` varchar(255) default NULL,
`OtherStreet` varchar(255) default NULL,
`OtherCity` varchar(255) default NULL,
`OtherState` varchar(255) default NULL,
`OtherPostalCode` varchar(255) default NULL,
`OtherCountry` varchar(255) default NULL,
`BusinessFax` varchar(255) default NULL,
`BusinessPhone` varchar(255) default NULL,
`BusinessPhone2` varchar(255) default NULL,
`CompanyMainPhone` varchar(255) default NULL,
`HomeFax` varchar(255) default NULL,
`HomePhone` varchar(255) default NULL,
`HomePhone2` varchar(255) default NULL,
`MobilePhone` varchar(255) default NULL,
`OtherFax` varchar(255) default NULL,
`OtherPhone` varchar(255) default NULL,
`PrimaryPhone` varchar(255) default NULL,
`Birthday` varchar(255) default NULL,
`Categories` varchar(255) default NULL,
`EmailAddress` varchar(255) default NULL,
`EmailDisplayName` varchar(255) default NULL,
`Email2Address` varchar(255) default NULL,
`Email2DisplayName` varchar(255) default NULL,
`Email3Address` varchar(255) default NULL,
`Email3DisplayName` varchar(255) default NULL,
`Initials` varchar(255) default NULL,
`Notes` longtext,
`WebPage` varchar(255) default NULL,
`imagename` varchar(255) default NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1810 ;

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Thanx in advance

Simjith
User avatar
JAB Creations
DevNet Resident
Posts: 2341
Joined: Thu Jan 13, 2005 6:44 pm
Location: Sarasota Florida
Contact:

Re: Importing Arabic text From MS Access to MySQL

Post by JAB Creations »

I'm hardly an expert in the field though my best guess is to use a language encoding that encompasses both character sets. UTF/Unicode comes to mind. When you look at the Collation in MySQL (I use phpMyAdmin) is it set to utf8_general_ci? Are there any special collation export options for MS Access?
simjith
Forum Newbie
Posts: 4
Joined: Sat Nov 08, 2008 10:25 am

Solved

Post by simjith »

Thanx a lot,
Had fixed the issue, in addition to your suggestion, followed the steps in

http://forums.mysql.com/read.php?103,209072,209072

and

http://forums.mysql.com/read.php?103,209072,209072

With Warm Regards

Simjith
mmj
Forum Contributor
Posts: 118
Joined: Fri Oct 31, 2008 4:00 pm

Re: Solved

Post by mmj »

simjith wrote:Thanx a lot,
Had fixed the issue, in addition to your suggestion, followed the steps in

http://forums.mysql.com/read.php?103,209072,209072

and

http://forums.mysql.com/read.php?103,209072,209072

With Warm Regards

Simjith
Pretty much what JAB was pointing to.
Post Reply