Re: [PHP-DB] Arabic characters displayed as garbage !!

[Han]

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: <[EMAIL PROTECTED]>
To: "Dre" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
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
<[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
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