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.......................