Membuat Tulisan Arab di WordPress

Membuat Tulisan Arab di WordPress ini saya posting aja disini daripada sekedar posting komentar. Terutama untuk postingnya mas ressay dan mas kuntop yang ada tulisan arab nya.

Setelah nyari semalaman akhirnya ketemu juga bagaimana cara menampilkan huruf arab di WordPress. Walaupun resiko nya di cemberutin istri :( .

Seperti biasa telusuri di Google dengan kata kunci “huruf arab di wordpress” ketemu banyak sekali.

Saya pilih yang berikut ini :

  • Posting dengan huruf Arab di WordPress
  • 3 Cara Menulis Huruf Arab dalam Blog WordPress
  • Mengatasi Problem Penulisan Fonts Arabic di WordPress
  • Selamat Idul Fitri 1430 H, Membuat Tulisan Arab di WordPress
  • How to Convert Character Set and Collation of WordPress Database ยป My Digital Life
  • Convert character set to utf8 in MySQL
  • Perl script to convert MySQL character set to utf8

Semua link dan cara diatas tidak membantu menyelesaikan masalah saya.

Ketemunya di artikel ini Convert latin1 to UTF-8 in MySQL

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.

Emang bener deh daripada dumping-editing-reloding data, apalagi pake script dan tools lain,  mending pake SQL statement, satu kali perintah selesai dah :) .

Caranya:

  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_private_messages 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;
ALTER TABLE wp_wp125_ads CONVERT TO CHARACTER SET utf8;
ALTER TABLE wp_yarpp_keyword_cache CONVERT TO CHARACTER SET utf8;
ALTER TABLE wp_yarpp_related_cache 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 membantu :)

Leave a Reply

Your email address will not be published. Required fields are marked *