Re: Arabic text storing problem
Hi, Thanks for the link Is there standalone jar/zip Just for auto_ef Also see Perl module Encode::Guess. There are others out there as well. Regards, Jeremy -- high performance mysql consulting www.provenscaling.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Arabic text storing problem
> 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:
> 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...
> >
>
>
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...
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 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...
