The whole thing doesnt have to do anything with the DB. Because what matters is the client or the gateway character-set ( browser in your case ) so if ur on windows u're probably posting data through charset=windows-1256 so if ur using HTML then use this encoding or if ur using XHTML u could put the charset in the xmlns or html tag. or as mentioned earlier by sending headers. Hope that helps. On Mon, 4 Oct 2004 15:26:09 +0100, Han <han@xxxxxxxxxxxxx> wrote: > 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 > > -- M.Saleh.E.G 97150-4779817 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
