Re: Arabic characters displayed as garbage !!

try using utf-8 character encoding, see http://dev.mysql.com/doc/mysql/en/Charset-Unicode-sets.html bastien

From: martin73@maxnet.co.nz To: "Dre" <dre00x@yahoo.com> CC: php-db@lists.php.net Subject: Re: [PHP-DB] Arabic characters displayed as garbage !! Date: Mon, 4 Oct 2004 14:36:01 +1300 (NZDT) 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

_________________________________________________________________ Powerful Parental Controls Let your child discover the best the Internet has to offer. http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines Start enjoying all the benefits of MSN® Premium right now and get the first two months FREE*.