This plugin will attempt to convert a wordpress or wordpress mu database with content in whatever character set to utf8. It uses the information provided
by this guide on
the wordpress codex site. Before using this plugin it is mandatory to have a working and recent backup of your database.
If anything goes wrong you will need this!
Keep in mind that this plugin has been tested thoroughly for wordpress mu, but only minimaly for wordpress.
Please contact me if you encounter any issues with WordPress, patches are always welcome.
The plugin performs the following steps. First it will show you all of the tables within the database used by wordpress or wordpress mu. Between the brackets
it shows the current character set. The plugin allows you to uncheck tables you do not want to convert to UTF8. Unless you know what you're doing it is
advised to convert the complete wordpress (mu) database to UTF8. After you have selected the tables for conversion and pressed the button convert columns
to binary counterparts for checked tables the plugin will go through all tables and look for columns of the type: char, varchar, tinytext, text, mediumtext,
longtext, enum and set. Columns of these types will be converted to their binary counterparts according the list below:
- char --> binary
- varchar --> varbinary
- tinytext --> tinyblob
- text --> blob
- mediumtext --> mediumblob
- longtext --> longblob
As you might have noticed the column types enum and set are not changed to a different type, instead the plugin will set those columns character set to binary.
The next step is setting all selected tables to the UTF8 character set (the plugin uses collation utf8_general_ci by default). Third, the plugin will set the
database's default character set to UTF8. Finally the plugin will switch all the columns back from their binary to their original types. Now you should have a
database converted to UTF8.
Note: Development for this plugin is made possible by VPRO Digitaal and started after encountering numerous solutions
including other plugins and none providing a 100% workable solution. If you need any help with this plugin, do not hesistate
to contact me. My company is available for hire ;)
UTF-8 Database Converter
Since the release of WordPress 2.2 the character set has been set by default to UTF-8 and the users
that come from previously versions of WordPress, may have some problems with the old Latin1 character set
and the new default UTF-8 character set.
This plugin has been designed and developed with the .........
Utf8ize
Convert all your database character sets to utf8, trying to follow Codex guides. You should use this if you are experiencing double utf8 encoding. You can check this by setting DB_CHARSET in your wp-config.php file to latin1 or commenting the line; if your characters look good now on your site than .........
vXor Convertor
vXor Convertor is an easy-to-use blog data plugin for WordPress. This utility is able to convert multiple data formats (MySQL, Acess and XML files exported by Blog Service Provider) to WordPress. No user intervention is required for the conversion.
vXor Convertor 是一款简单易用的 WordPress 博客数据.........
Formidable Forms
Build WordPress forms the fast and simple way with a simple drag-and-drop interface (and a visual form styler in version 2.0). Create custom Formidable forms or generate them from a template with this stunning WordPress form plugin.
View Documentation
Contribute on Github...
GAM DB Backup
GAM DB Backup is a lightweight database backup plugin for any WordPress site....
WP Clean Up
WP Clean Up can help us to clean up the wordpress database by removing "revision" "draft" "auto draft" "moderated comments" "spam comments" "trash comments" "orphan postmeta" "orphan commentmeta" "orphan relationships" "dashboard transient feed".
It allows you to optimize your WordPress database wit.........
WP Easy full backup
This plugin creates a file with all files and directories on a site while maintaining its structure.
At the root of the archive file is created as "DATABASE_BACKUP.sql" full dump database
site. Fully compatible with phpMyAdmin (menu - Import)....
WP Popup Plugin
After the frustration with the existing popup plugins I decided to create a new WordPress Popup plugin from scratch named WP Popup Plugin and after months of development and hard work the first version is ready Please download the plugin and use it on your site and let me know your feedback. I hope .........
BackWPup Free - WordPress Backup Plugin
The backup plugin BackWPup Free can be used to save your complete installation including /wp-content/ and push them to an external Backup Service, like Dropbox, S3, FTP and many more, see list below. With a single backup .zip file you are able to easily restore an installation. Please understand: th.........
Easy WP Cleaner
Easy WP Cleaner is user friendly plugin to clean unnecessary data from WordPress database like "revision", "draft", "auto draft", "moderated comments", "spam comments", "trash comments", "orphan postmeta", "orphan commentmeta", "orphan relationships", "dashboard transient feed" and this plugin also .........