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

Reply via email to