CONVERT DRUPAL 6 MYSQL 5 DATABASE to UTF8

ALTER TABLE `access` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE `actions` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE `actions_aid` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE `authmap` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE `batch` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE `blocks` CONVERT TO … Citește mai multCONVERT DRUPAL 6 MYSQL 5 DATABASE to UTF8

WordPress – How to convert database to unicode UTF8

Currently in WordPress 2.5 + UTF8 is enabled by default, but usually after installing of WordPress the MYSQL database use another collation. Here is the MYSQL script that will transform your database. ALTER TABLE `wp_comments` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE `wp_links` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE `wp_options` … Citește mai multWordPress – How to convert database to unicode UTF8