[PHP-DB] Any hints lantin1 utf-8

2006-11-24 Thread Abu Mosaab
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

Re: [PHP-DB] Any hints lantin1 utf-8

2006-11-24 Thread Niel Archer
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

Re: [PHP-DB] Any hints lantin1 utf-8

2006-11-24 Thread Abu Mosaab
@lists.php.net To: php-db@lists.php.net Subject: Re: [PHP-DB] 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

Re: [PHP-DB] Any hints lantin1 utf-8

2006-11-24 Thread Niel Archer
Hi I don't use phpMyAdmin myself and I can't remember if it supports UTF-8 encoding Whichever extension that your PHP is using is likely doing a conversion. this is something that the MySQL libraries handle. You can use this to extract the data from the tables and save it. As a test, dump a