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