Jika anda ingin membuat wordpress di hostingan anda support tulisan arab daripada dumping-editing-reloding data, atau menggunakan script dan tools lain,  lebih baik ,menggunakan  SQL statement, hanya dengan satu kali perintah cepat dan aman bagi database anda

Dibawah ini cara untuk membuat wordpress support tulisan arab:

Alternative Method

Instead of using the above method of dumping and reloading your data, you can use the ALTER TABLE/DATABASE SQL statements to convert your data.

For each table you want to convert to utf8, use the following statement.

ALTER TABLE <table_name> CONVERT TO CHARACTER SET utf8;

This will automatically convert all text columns to utf8.

To set the default character set for a database, use the following statement.

ALTER DATABASE <database_name> CHARACTER SET utf8;

This does not affect any existing tables, but any future tables created in this database will use utf8 by default.

langkah – langkah:

1. login ke phpmyadmin
2. klik SQL (Run SQL query/queries)  dan copy paste ini

ALTER DATABASE nama_database_anda CHARACTER SET utf8;
ALTER TABLE wp_comments CONVERT TO CHARACTER SET utf8;
ALTER TABLE wp_links CONVERT TO CHARACTER SET utf8;
ALTER TABLE wp_newsletter CONVERT TO CHARACTER SET utf8;
ALTER TABLE wp_options CONVERT TO CHARACTER SET utf8;
ALTER TABLE wp_postmeta CONVERT TO CHARACTER SET utf8;
ALTER TABLE wp_posts CONVERT TO CHARACTER SET utf8;
ALTER TABLE wp_terms CONVERT TO CHARACTER SET utf8;
ALTER TABLE wp_term_relationships CONVERT TO CHARACTER SET utf8;
ALTER TABLE wp_term_taxonomy CONVERT TO CHARACTER SET utf8;
ALTER TABLE wp_usermeta CONVERT TO CHARACTER SET utf8;
ALTER TABLE wp_users CONVERT TO CHARACTER SET utf8;

Jangan lupa dibaris pertama di atas nama_database_anda ganti dengan nama data base anda, nama tabel-tabelnya juga disesuaikan dengan nama tabel database anda.

Semoga bermanfaat