[SOLVED] Importing Arabic text From MS Access to MySQL

[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

[fenway]

You need UTF-8 charsets.

[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