Re: Arabic characters displayed as garbage !!

["Han" <han@xxxxxxxxxxxxx>]

Hi,

I might be able to help. I've done a website that uses Chinese characters. I 
have to store the data in a BLOP mysql field. Then use the correct ISO for 
the webpage display.

Try that.

Han
----- Original Message ----- 
From: <martin73@xxxxxxxxxxxx>
To: "Dre" <dre00x@xxxxxxxxx>
Cc: <php-db@xxxxxxxxxxxxx>
Sent: Monday, October 04, 2004 2:36 AM
Subject: Re:  Arabic characters displayed as garbage !!


> 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@xxxxxxxxxxxx> wrote in message
> > news:62223.202.14.141.254.1096843994.squirrel@xxxxxxxxxxxxxxxxxxxxxxx
> > > 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
>
> --
> 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