unicode - Arabic - data restore problem

[Ted Harper]

Hello,

I have a website hosted by hosting company (using PLESK control panel) and the content is in Arabic language that uses MySQL database. The table holds fields in Latin1_general_ci with data in Arabic language. I can update the table with Arabic data no problem from php input screen. The problem started when I wanted to restore the data from dump data file (UFT8 format). the data in the dump file is correct, but when I save it (or restore it) into MySQL the output of the restore comes to display different than what was in the data file. For example:

I read from data dump file (UTF8): سماء
after save, MySQL field displays: سٿاء (which is not exactly the same). As you see, the input data and output are not the same, but close.

The first line outputs in Arabic (on web page - correct) : سورية
whie the second line outputs (on web page - not correct): سٿرٿة

I've been working on this problem all day and my hosting company who moved servers and had to restore data (what caused me this issue), told me it is strictly mySQL issue.

How can beat this problem? help help...



Edited 2 time(s). Last edit at 07/24/2006 12:05AM by Ted Harper.