> Thanks for the link
> Is there standalone jar/zip Just for auto_ef
Not that I know of.
Since I work on Solaris most of the time, it's not an issue for me.
It's probably a bit much to install an OS just for a single utility...
Company allegiance aside [I work for Sun], the Solaris Express Developer
Edition [x86] is a wonderfully simple install.
~mm
>
> Thanks again
> Martin--
> ----- Original Message -----
> From: "Michael Monaghan" <[EMAIL PROTECTED]>
> To: "Bharat" <[EMAIL PROTECTED]>
> Cc: <mysql@lists.mysql.com>
> Sent: Wednesday, November 14, 2007 9:39 AM
> Subject: Re: Arabic text storing problem
>
>
> > > 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.......................
> >
>
>
