Re: Arabic characters displayed as garbage !!
| From: | Han | Date: | Mon, 04 Oct 2004 14:26:09 +0000 |
| Subject: | Re: Arabic characters displayed as garbage !! | ||
| References: | 1 2 3 4 5 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-36577@lists.php.net to get a copy of this message | ||
Sorry, I meant BLOB, not BLOP.
Han.
----- Original Message ----- From: "Han" <han@fonedream.com>
To: <martin73@maxnet.co.nz>; "Dre" <dre00x@yahoo.com>
Cc: <php-db@lists.php.net>
Sent: Monday, October 04, 2004 3:24 PM
Subject: Re: [PHP-DB] 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. CheersHi, I'm working on a website that needs to save and display Arabicyes 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)I'm using MySQL database and no matter how I insert the data eithercharacters.phpMyAdmin or inserting it using a script of my own, when I try tousing(display) the data I previously saved (which contains Arabicshowthe 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 thecharacters),one //=========================================================== <?php include("db.php"); $result = mysql_query("select * from mem_applications"); if ($result) { while ($row = mysql_fetch_array($result)) {followingecho $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