Thanks Neil,
But what would be the best way to convert my Arabic Texts which were stored
through a php script into a latin1 table back to UTF-8.
I wonder WHY is it displayed correctly when retrieved through the php
scripts (!!??)
M.
From: Niel Archer <niel@xxxxxxxxxxxxx>
Reply To: php-db@xxxxxxxxxxxxx
To: php-db@xxxxxxxxxxxxx
Subject: Re: Any hints lantin1 utf-8
Sent: Friday, November 24, 2006 5:56 PM
Hi
If you're storing non-latin character in a latin-1 table you are bound
to get this problem. phpMyAdmin is simply showing you what you put
there as far as it is concerned.
You should switch to using an alternative encoding for the character set.
UTF-8 would likely be best for you. Back up all the data before making
the change, or it WILL be corrupted.
If you primarily use non-latin character sets, I'd recommend making
UTF-8 the default database character set
Niel
From: Abu Mosaab <abumosaab1@xxxxxxxxxxx>
To: php-db@xxxxxxxxxxxxx
Subject: Any hints lantin1 utf-8
Sent: Friday, November 24, 2006 12:48 PM
Would you please give any suggestions or hints about storing data into
MySQL.
I have a site where I use MySQL database to store usually Arabic texts. I
use a custom contorl panel to store/retrieve the Arabic texts from the
database. Everything up to now is OK.
But When I try to open the database directly using (say phpmyadmin) the
Arabic texts does not appear correctly. Its appears something like 'ãä ÇáÐí
äÇÕÑ ÅÓÑÇÆíáÇð ¿'.
The default charset of the database/table is latin1. I know it's a matter of
encoding used. But how can I be able to view the data directly correctly ???
_________________________________________________________________
FREE pop-up blocking with the new MSN Toolbar - get it now!
http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
