Hi,
I use PHP5 with MySQL5 on Windows with Apache. I do store "Arabic" in my tables using utf-8 charset. I have a "Linux" hosting where I create & store my databases. Because of Windows problems and the need to reinstall Windows, I allways need to restore my databases from on my hosting account. The problem is: When I make a backup & restore it on my PC, "Arabic" data in database arrive runed and don't display properly on web pages!
The strange is that if I make that backup FROM localhost then restore them on the same localhost, data remains well and displays properly on web pages. Anyway, I want to tell that I have tryed many applications making backup & restore like: MySQL Administrator; PhpMyAdmin and Navicat.
I use PHP5 with MySQL5 on Windows with Apache. I do store "Arabic" in my tables using utf-8 charset. I have a "Linux" hosting where I create & store my databases. Because of Windows problems and the need to reinstall Windows, I allways need to restore my databases from on my hosting account. The problem is: When I make a backup & restore it on my PC, "Arabic" data in database arrive runed and don't display properly on web pages!
The strange is that if I make that backup FROM localhost then restore them on the same localhost, data remains well and displays properly on web pages. Anyway, I want to tell that I have tryed many applications making backup & restore like: MySQL Administrator; PhpMyAdmin and Navicat.