bastien
From: martin73@xxxxxxxxxxxx To: "Dre" <dre00x@xxxxxxxxx> CC: php-db@xxxxxxxxxxxxx Subject: Re: 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@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
_________________________________________________________________
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*.
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
