jeudi 1 janvier 2015

Can't write arabic text into mysql database using mysql prompt


I had a local table with arabic values.when exported i got the following query.



DROP TABLE IF EXISTS `type`;
CREATE TABLE IF NOT EXISTS `type` (
`bs_id` int(11) NOT NULL AUTO_INCREMENT,
`types` varchar(250) NOT NULL,
PRIMARY KEY (`bs_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Data for table `business_type`
--

INSERT INTO `type` (`bs_id`, `types`) VALUES
('1', 'صناعة'),
('2', 'معارض'),
('3', 'أسواق'),
('4', 'إستيراد وتوزيع'),
('5', 'خدمات'),
('6', 'إستشارات'),
('7', 'أخرى');


I want to create this table on server so i just copied the above query and run it on server terminal.The query works fine but the values in table is showing like ".....".


tried this



SET NAMES utf8;


before inserting the values,but failed.I don't have a cpanel installed on server.Command prompt is the only option.


Can anyone help!!


Thanks





Aucun commentaire:

Enregistrer un commentaire