> 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
When you retrieve this content, how are you viewing it? - browser? terminal?
For the browser, it needs to be told what encoding your data is in - UTF-8.
So, your data could be perfect - just the browser might be interpreting it
as ASCII etc.
If viewing the results through the browser, do View ->Set Encoding -> UTF-8
this content it is display something like ASCII value("٠عاÙ"ÙSØ(c)
> ادارØ(c) اÙ"Ù^Ù,ت").
>
> one more thing that when i edit any fields with arabic text.
are you editing through a web interface - a web form?
If so, the web page on which the web form sits needs to be in UTF-8.-
otherwise it'll send wrongly encoded strings back to the database.
[btw / off topic. Solaris 10 has a great utility for determining the
encoding of any text file. The utility is auto_ef [auto encoding finder].
So you could output to a text the contents of your db and run auto_ef on it.
It'll tell you definitively the content encoding.
Free Solaris download for x86 platforms at developers.sun.com/sxde ]
~mm
> 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.......................
