This week's book giveaway is in the OCPJP forum. We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line! See this thread for details.
Hi guys , I have created latin database called arabicUser with no values, then I converted to utf8 using this command below in order to insert arabic letters:
here is my table arabicUser:
create table arabicUser(
userID int not null auto_increment,
I converted it using ALTER TABLE arabicUser CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
now it is like this:
Create Table: CREATE TABLE `arabicuser` (
`userID` int(11) NOT NULL auto_increment
`name` varchar(20) default NULL,
`university` varchar(20) default NULL,
`profession` varchar(20) default NULL,
PRIMARY KEY (`userID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
does it mean I can now insert arabic characters into table , I have tried this below:
insert into arabicUser(name, university, profession)
but it shows not correct characters something not understood, why is that , and if I put
select * from arabicuser;
it shows also the not clear characters .
please tell me where I am wrong what step I miss to insert arabic characters .