MySQL Exporting Arabic/Persian Characters
<p>I'm new to MySQL and i'm working on it through phpMyAdmin.
My problem is that i have imported some tables with (.sql) extension into a database with: UTF8_general_ci format and it contains some Arabic or Persian characters. However, when i export these data into an Excel file, they appear as the following:</p>

<p>The original value: أحمد الكمالي
The exported value: Ø£Ø­Ù…Ø¯ Â Ø§Ù„ÙƒÙ…Ø§Ù„ÙŠ</p>

<p>I have searched and looked for this issue and tried to solve it by making the output and the server connection with the same format UTF8_general_ci. But, for some reason which i don't know, the phpMyAdmin doesn't allow me to change to the same format, it forces me to chose this: UTF8mb4_general_ci
Anyway, when i export the data, i'm making sure that the format is in UTF8 but it still appears like that.</p>

<p>How can i solve it or fix it? </p>

<p>Note: Here are some screenshots if you want to check organized by numbers.
<a href="http://www.megafileupload.com/rbt5/Screenshots.rar" rel="nofollow">http://www.megafileupload.com/rbt5/Screenshots.rar</a></p>