Convert MySQL Database to UTF-8 in Wordpress | /en/2009/05/convert-mysql-database-to-utf-8-in-wordpress/

Guest *r-sn.com* @ 2009-06-28 21:22:59 originally posted:

thank you ..
plugin nice ..
but links i have not Convert to UTF-8 .. :x

Guest *r-sn.com* @ 2009-06-28 21:24:32 originally posted:

Example:
% d8% a7% d8% aa% d8% b5% d9% 84 -% d8% a8% d9% 86% d8% a7
I want to convert:
اتصل بنا

Guest *charlesss* @ 2009-07-05 20:12:22 originally posted:

Love the blog mate, keep up the good work - I'll definitely recommend your blog to some friends of mine ^^

Guest *Saevar* @ 2009-07-17 18:16:09 originally posted:

Thank you :D but i have 1 question, i have sql file that was using iso-8859-1 for 2 years and then the user change the code to utf-8, will this repair and convert iso-8859-1 to utf8 ?

Guest *Derek* @ 2009-09-06 16:07:07 originally posted:

Worked perfectly. You just saved me a lot of time! Thanks so much!

Derek

Guest *meandi* @ 2009-10-07 13:20:55 originally posted:

thank you very much for the plugin!

Guest *Andrew* @ 2009-11-15 10:31:36 originally posted:

Thank you so much for this plugin. I just applied it to my installation, and it worked perfectly with no troubles.

Guest *WS* @ 2010-01-22 06:16:55 originally posted:

Dude, you rock! I've been trying to convert my db, which was a mess of latin and utf8. I found the previous WP plug-in and it butchered my posts, clipping them after any non-latin character (I write in English, but use em-dashes like their going out of style).

Your plugin worked without a hitch! You have no idea how grateful I am! Thanks again for fixing the previous version :)

Guest *GrgoljBlaster* @ 2010-05-06 23:53:28 originally posted:

Thank you! Plugin works great, and I can finally use UTF8 on my website

Guest *Ben* @ 2010-05-26 16:06:32 originally posted:

Thanks for the great plugin. I'm getting an error. Do you have any idea what this means?

wp_bdprss_items changed to UTF-8 successfully.
---- item_feed_url changed to UTF-8 successfully.
SQL Error:
Specified key was too long; max key length is 1000 bytes

Guest *anthony* @ 2010-07-06 21:07:26 originally posted:

I first noticed a character set encoding problem ( see "Victim?s parents to speak on bullycase" here: http://carmel-indiana.us/page/6/ ). What was supposed to be an apostrophe was displaying as a question mark instead. I installed and activated the plugin. It indicated that it had fixed the encoding. But I don't see that the post has been changed. Is the plugin supposed to fix posts that were posted prior to installation of the plugin?

Guest *Joan Piedra* @ 2010-10-19 05:43:36 originally posted:

You sir, are a lifesaver. Thank you very much for this plugin.

Guest *Laura* @ 2010-11-23 08:47:41 originally posted:

When I ran the plug-in I got the following:

wp_posts changed to UTF-8 successfully.
SQL Error:
Column 'post_content' cannot be part of FULLTEXT index

Any clue as to what I can do about the error and get rid of the charset issue?

Thanks much

Guest *peter* @ 2011-01-14 14:01:22 originally posted:

hello!

i made an upgrade from 2.0.7 to 3.1 but i have problems it will not work
http://www.apfel.at/tagesgedanken1/?p=1259
from december on i copy the new articel new into it, so from
http://www.apfel.at/tagesgedanken1/?p=1
to
http://www.apfel.at/tagesgedanken1/?p=2222
the article have the problem, befor it was iso-8859-1

could you help?

thank you
regards
peter

Guest *peter* @ 2011-01-15 03:37:38 originally posted:

hello!

thank you for your wonderfull work of the plugin

i tested it but in my case it will not work
from http://www.apfel.at/tagesgedanken1/?p=2224 to the last
http://www.apfel.at/tagesgedanken1/?p=2269 is ok
i put it after upgrade from 2.0.7 into 3.1 into

befor the old one i have iso-8859-1 so i did the upgrade with your plugin
from http://www.apfel.at/tagesgedanken1/?p=1
to
http://www.apfel.at/tagesgedanken1/?p=2222
but it will not change, what should i do?

regards
peter

Guest *peter* @ 2011-01-17 02:03:57 originally posted:

thank you very much,

In other words, it does not modify the data in your database

to you know how i could modify the database?

regards
peter

Guest *Vlad* @ 2011-10-14 15:47:39 originally posted:

Hello,

I have made one fix to your excellent plugin. On line 132, replace

$sql4 = "ALTER TABLE $table CHANGE $field_name $field_name $field_type CHARACTER SET utf8 COLLATE utf8_bin";

with

$sql4 = "ALTER TABLE $table CHANGE $field_name $field_name $field_type CHARACTER SET utf8 COLLATE utf8_general_ci";

This is so that when you are manually editing/viewing the field within phpMyAdmin, the text that is stored in the field will be human readable. Without this change, it appears as binary-encoded data, which is very inconvenient to use.

Guest *Topup* @ 2013-02-09 09:52:37 originally posted:

very good plugin.. 1 give u 5 star !!!!
i love it !!

Guest *Bindoo* @ 2014-05-03 15:40:48 originally posted:

Hi. Urgent. Looks like running this plugin on my 3.8.1 deleted all the content inside Pages. The Posts are fine, but Pages are now empty. Please help! What to do?