Ways to copy arabic words from database

Asked By romasfleeman 40 points N/A Posted on - 01/31/2013

Finally migrating my files to another database with some issues on a few data. I want to copy arabic words from database but it translates into english letters. How do I copy the data as they are in MY SQL server?

• Status: Open
• Question Views: 1130
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MySQL Server

Answered By Franke Mary 10 points N/A #197342

Ways to copy arabic words from database

Hi,

Make sure that in IE, View -> Encoding is set to UTF -8, and you need to change the Locale of your windows OS to Arabic

(go to Control Panel, Regions and Language settings -> Language -> Arabic).

Another option:

Open up your wp-config.php and find this line:

 define('DB_CHARSET', 'utf8');

Last option:

Check in Settings > Reading that you've got encoding set to UTF-8.

Hope to enjoy it.

Thanking you.

Franke Mary

About Franke Mary

Questions
3

Answers
102

Best Answers
23

• Vote Up 0 Vote Down

• Posted on - 02/07/2013
• Question Category: MySQL Server