Re: Arabic characters displayed as garbage !!

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Sorry, I meant BLOB, not BLOP.

Han.


----- Original Message ----- From: "Han" <han@xxxxxxxxxxxxx>
To: <martin73@xxxxxxxxxxxx>; "Dre" <dre00x@xxxxxxxxx>
Cc: <php-db@xxxxxxxxxxxxx>
Sent: Monday, October 04, 2004 3:24 PM
Subject: 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@xxxxxxxxxxxx>
To: "Dre" <dre00x@xxxxxxxxx>
Cc: <php-db@xxxxxxxxxxxxx>
Sent: Monday, October 04, 2004 2:36 AM
Subject: Re: 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@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



-- 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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux