Re: Arabic characters displayed as garbage !!
| From: | Dre | Date: | Mon, 04 Oct 2004 08:06:38 +0000 |
| Subject: | Re: Arabic characters displayed as garbage !! | ||
| References: | 1 2 3 4 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-36570@lists.php.net to get a copy of this message | ||
Thanks I will take a look at it
BR
<martin73@maxnet.co.nz> wrote in message
news:13894.202.14.141.254.1096853761.squirrel@webmail.maxnet.co.nz...
> By default, MySQL uses the ISO-8859-1 (Latin1) character set. I guess you
> need to set this parameter to something suitable for Arabic (if it is
> supported by MySQL). I suggest you read "The Character Set Used for Data
> and Sorting" part of MySQL manual. That's all I can help with.
>
> Cheers
>
> > yes I did .. and the problem only happens for arabic text stored in
> > database
> >
> > <martin73@maxnet.co.nz> wrote in message
> >
> > news:62223.202.14.141.254.1096843994.squirrel@webmail.maxnet.co.nz...
> >> Did you set a character encoding on your page to Arabic? (eg.
> >> ISO-8859-6)
> >>
> >> > Hi,
> >> >
> >> > I'm working on a website that needs to save and display Arabic
> > characters.
> >> > I'm using MySQL database and no matter how I insert the data either
> > using
> >> > phpMyAdmin or inserting it using a script of my own, when I try to
> >> show
> >> > (display) the data I previously saved (which contains Arabic
> > characters),
> >> > the output is rubbish and has no relation with the words I saved
> >> >
> >> > the script I'm using for displaying the data is as simple as the
> > following
> >> > one
> >> >
> >> > //===========================================================
> >> > <?php
> >> > include("db.php");
> >> > $result = mysql_query("select * from mem_applications");
> >> > if ($result)
> >> > {
> >> > while ($row = mysql_fetch_array($result))
> >> > {
> >> > echo $row['first_name'];
> >> > echo "<br>";
> >> > echo $row['mid_name'];
> >> > echo "<br>";
> >> > echo $row['last_name'];
> >> > echo "<br>";
> >> > }
> >> > }
> >> > ?>
> >> > //===========================================================
> >> >
> >> > Thanks in advance
> >> >
> >> > --
> >> > PHP Database Mailing List (http://www.php.net/)
> >> > To unsubscribe, visit:
> >> > http://www.php.net/unsub.php
> >> >
> >> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >