i have one problem with Arabic text. I have created database with charaterset utf8. when i insatal sql file all the content which is arabic that content stored as arabic. but when i retrieve this content it is display something like ASCII value("ÙØ¹Ø§Ù"ÙSØ© ادارة اÙ"Ù^Ù,ت").
one more thing that when i edit any fields with arabic text. it is storing the text like ("??????????"), but when i retrieve it display proper rabic text. my table structure like that CREATE TABLE `mdl_jobs` ( `id` int(11) NOT NULL auto_increment, `company` varchar(200) collate utf8_unicode_ci default NULL, `position` varchar(200) collate utf8_unicode_ci default NULL, `location` varchar(100) collate utf8_unicode_ci default NULL, `emp_status` tinyint(1) default '1', `qualification` varchar(200) collate utf8_unicode_ci default NULL, `descr` text collate utf8_unicode_ci, `posteddate` bigint(10) unsigned default NULL, `expdate` bigint(10) unsigned default NULL, `status` int(11) default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=27 ; -- -- Dumping data for table `mdl_jobs` -- Please help me.......................