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