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@maxnet.co.nz> To: "Dre" <dre00x@yahoo.com> Cc: <php-db@lists.php.net> Sent: Monday, October 04, 2004 2:36 AM Subject: Re: [PHP-DB] 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@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