Re: [PHP-DB] Arabic characters displayed as garbage !!
The whole thing doesnt have to do anything with the DB. Because what
matters is the client or the gateway character-set ( browser in your
case ) so if ur on windows u're probably posting data through
charset=windows-1256 so if ur using HTML then use this encoding or if
ur using XHTML u could put the charset in the xmlns or html tag.
or as mentioned earlier by sending headers.
Hope that helps.
On Mon, 4 Oct 2004 15:26:09 +0100, Han <[EMAIL PROTECTED]> wrote:
> Sorry, I meant BLOB, not BLOP.
>
> Han.
>
>
>
>
> - Original Message -
> From: "Han" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>; "Dre" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> 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: <[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
> >>>> >
> >>>> > //===
> >>>> > >>>> > include("db.php");
> >>>> > $result = mysql_query("select * from mem_applications");
> >>>> > if ($result)
> >>>> > {
> >>>> >while ($row = mysql_fetch_array($result))
> >>>> >{
> >>>> > echo $row['first_name'];
> >>>> > echo "";
> >>>> > echo $row['mid_name'];
> >>>> > echo "";
> >>>> > echo $row['last_name'];
> >>>> > echo "";
> >>>> >}
> >>>> > }
> >>>> > ?>
> >>>> > //===
> >>>> >
> >>>> > 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
>
>
--
M.Saleh.E.G
97150-4779817
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Arabic characters displayed as garbage !!
Sorry, I meant BLOB, not BLOP.
Han.
- Original Message -
From: "Han" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "Dre" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
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: <[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
>
> //===
> include("db.php");
> $result = mysql_query("select * from mem_applications");
> if ($result)
> {
>while ($row = mysql_fetch_array($result))
>{
> echo $row['first_name'];
> echo "";
> echo $row['mid_name'];
> echo "";
> echo $row['last_name'];
> echo "";
>}
> }
> ?>
> //===
>
> 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
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: <[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
>
> //===
> include("db.php");
> $result = mysql_query("select * from mem_applications");
> if ($result)
> {
>while ($row = mysql_fetch_array($result))
>{
> echo $row['first_name'];
> echo "";
> echo $row['mid_name'];
> echo "";
> echo $row['last_name'];
> echo "";
>}
> }
> ?>
> //===
>
> 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
Re: [PHP-DB] Arabic characters displayed as garbage !!
try using utf-8 character encoding, see
http://dev.mysql.com/doc/mysql/en/Charset-Unicode-sets.html
bastien
From: [EMAIL PROTECTED]
To: "Dre" <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] 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
>
> <[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
>> >
>> > //===
>> > > > include("db.php");
>> > $result = mysql_query("select * from mem_applications");
>> > if ($result)
>> > {
>> >while ($row = mysql_fetch_array($result))
>> >{
>> > echo $row['first_name'];
>> > echo "";
>> > echo $row['mid_name'];
>> > echo "";
>> > echo $row['last_name'];
>> > echo "";
>> >}
>> > }
>> > ?>
>> > //===
>> >
>> > 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
Re: [PHP-DB] Arabic characters displayed as garbage !!
Thanks I will take a look at it
BR
<[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> 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
> >> >
> >> > //===
> >> > >> > include("db.php");
> >> > $result = mysql_query("select * from mem_applications");
> >> > if ($result)
> >> > {
> >> >while ($row = mysql_fetch_array($result))
> >> >{
> >> > echo $row['first_name'];
> >> > echo "";
> >> > echo $row['mid_name'];
> >> > echo "";
> >> > echo $row['last_name'];
> >> > echo "";
> >> >}
> >> > }
> >> > ?>
> >> > //===
> >> >
> >> > 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
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
>> >
>> > //===
>> > > > include("db.php");
>> > $result = mysql_query("select * from mem_applications");
>> > if ($result)
>> > {
>> >while ($row = mysql_fetch_array($result))
>> >{
>> > echo $row['first_name'];
>> > echo "";
>> > echo $row['mid_name'];
>> > echo "";
>> > echo $row['last_name'];
>> > echo "";
>> >}
>> > }
>> > ?>
>> > //===
>> >
>> > 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
Re: [PHP-DB] Arabic characters displayed as garbage !!
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
> >
> > //===
> > > include("db.php");
> > $result = mysql_query("select * from mem_applications");
> > if ($result)
> > {
> >while ($row = mysql_fetch_array($result))
> >{
> > echo $row['first_name'];
> > echo "";
> > echo $row['mid_name'];
> > echo "";
> > echo $row['last_name'];
> > echo "";
> >}
> > }
> > ?>
> > //===
> >
> > 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
Re: [PHP-DB] Arabic characters displayed as garbage !!
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
>
> //===
> include("db.php");
> $result = mysql_query("select * from mem_applications");
> if ($result)
> {
>while ($row = mysql_fetch_array($result))
>{
> echo $row['first_name'];
> echo "";
> echo $row['mid_name'];
> echo "";
> echo $row['last_name'];
> echo "";
>}
> }
> ?>
> //===
>
> 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-DB] Arabic characters displayed as garbage !!
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 //=== "; echo $row['mid_name']; echo ""; echo $row['last_name']; echo ""; } } ?> //=== Thanks in advance -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
