Re: Arabic characters displayed as garbage !!

["Han" <han@xxxxxxxxxxxxx>]

Sorry, I meant BLOB, not BLOP.

Han.


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


> 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

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php