1ALTER TABLE {$prefix}posts CONVERT TO CHARACTER SET binary; 2ALTER TABLE {$prefix}postinfo CONVERT TO CHARACTER SET binary; 3ALTER TABLE {$prefix}posttype CONVERT TO CHARACTER SET binary; 4ALTER TABLE {$prefix}poststatus CONVERT TO CHARACTER SET binary; 5ALTER TABLE {$prefix}options CONVERT TO CHARACTER SET binary; 6ALTER TABLE {$prefix}users CONVERT TO CHARACTER SET binary; 7ALTER TABLE {$prefix}userinfo CONVERT TO CHARACTER SET binary; 8ALTER TABLE {$prefix}tags CONVERT TO CHARACTER SET binary; 9ALTER TABLE {$prefix}tag2post CONVERT TO CHARACTER SET binary; 10ALTER TABLE {$prefix}comments CONVERT TO CHARACTER SET binary; 11ALTER TABLE {$prefix}commentinfo CONVERT TO CHARACTER SET binary; 12ALTER TABLE {$prefix}rewrite_rules CONVERT TO CHARACTER SET binary; 13ALTER TABLE {$prefix}crontab CONVERT TO CHARACTER SET binary; 14ALTER TABLE {$prefix}log CONVERT TO CHARACTER SET binary; 15ALTER TABLE {$prefix}log_types CONVERT TO CHARACTER SET binary; 16ALTER TABLE {$prefix}groups CONVERT TO CHARACTER SET binary; 17ALTER TABLE {$prefix}users_groups CONVERT TO CHARACTER SET binary; 18ALTER TABLE {$prefix}groups_permissions CONVERT TO CHARACTER SET binary; 19ALTER TABLE {$prefix}sessions CONVERT TO CHARACTER SET binary; 20ALTER TABLE {$prefix}posts CONVERT TO CHARACTER SET binary; 21ALTER TABLE {$prefix}postinfo CONVERT TO CHARACTER SET binary; 22ALTER TABLE {$prefix}posttype CONVERT TO CHARACTER SET binary; 23ALTER TABLE {$prefix}poststatus CONVERT TO CHARACTER SET binary; 24ALTER TABLE {$prefix}options CONVERT TO CHARACTER SET binary; 25ALTER TABLE {$prefix}users CONVERT TO CHARACTER SET binary; 26ALTER TABLE {$prefix}userinfo CONVERT TO CHARACTER SET binary; 27ALTER TABLE {$prefix}tags CONVERT TO CHARACTER SET binary; 28ALTER TABLE {$prefix}tag2post CONVERT TO CHARACTER SET binary; 29ALTER TABLE {$prefix}comments CONVERT TO CHARACTER SET binary; 30ALTER TABLE {$prefix}commentinfo CONVERT TO CHARACTER SET binary; 31ALTER TABLE {$prefix}rewrite_rules CONVERT TO CHARACTER SET binary; 32ALTER TABLE {$prefix}crontab CONVERT TO CHARACTER SET binary; 33ALTER TABLE {$prefix}log CONVERT TO CHARACTER SET binary; 34ALTER TABLE {$prefix}log_types CONVERT TO CHARACTER SET binary; 35ALTER TABLE {$prefix}groups CONVERT TO CHARACTER SET binary; 36ALTER TABLE {$prefix}users_groups CONVERT TO CHARACTER SET binary; 37ALTER TABLE {$prefix}groups_permissions CONVERT TO CHARACTER SET binary; 38ALTER TABLE {$prefix}sessions CONVERT TO CHARACTER SET binary; 39 40ALTER TABLE {$prefix}posts CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; 41ALTER TABLE {$prefix}postinfo CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; 42ALTER TABLE {$prefix}posttype CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; 43ALTER TABLE {$prefix}poststatus CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; 44ALTER TABLE {$prefix}options CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; 45ALTER TABLE {$prefix}users CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; 46ALTER TABLE {$prefix}userinfo CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; 47ALTER TABLE {$prefix}tags CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; 48ALTER TABLE {$prefix}tag2post CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; 49ALTER TABLE {$prefix}comments CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; 50ALTER TABLE {$prefix}commentinfo CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; 51ALTER TABLE {$prefix}rewrite_rules CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; 52ALTER TABLE {$prefix}crontab CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; 53ALTER TABLE {$prefix}log CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; 54ALTER TABLE {$prefix}log_types CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; 55ALTER TABLE {$prefix}groups CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; 56ALTER TABLE {$prefix}users_groups CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; 57ALTER TABLE {$prefix}groups_permissions CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; 58ALTER TABLE {$prefix}sessions CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; 59ALTER TABLE {$prefix}posts CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; 60ALTER TABLE {$prefix}postinfo CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; 61ALTER TABLE {$prefix}posttype CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; 62ALTER TABLE {$prefix}poststatus CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; 63ALTER TABLE {$prefix}options CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; 64ALTER TABLE {$prefix}users CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; 65ALTER TABLE {$prefix}userinfo CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; 66ALTER TABLE {$prefix}tags CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; 67ALTER TABLE {$prefix}tag2post CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; 68ALTER TABLE {$prefix}comments CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; 69ALTER TABLE {$prefix}commentinfo CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; 70ALTER TABLE {$prefix}rewrite_rules CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; 71ALTER TABLE {$prefix}crontab CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; 72ALTER TABLE {$prefix}log CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; 73ALTER TABLE {$prefix}log_types CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; 74ALTER TABLE {$prefix}groups CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; 75ALTER TABLE {$prefix}users_groups CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; 76ALTER TABLE {$prefix}groups_permissions CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; 77ALTER TABLE {$prefix}sessions CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; 78 79ALTER TABLE {$prefix}posts DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 80ALTER TABLE {$prefix}postinfo DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 81ALTER TABLE {$prefix}posttype DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 82ALTER TABLE {$prefix}poststatus DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 83ALTER TABLE {$prefix}options DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 84ALTER TABLE {$prefix}users DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 85ALTER TABLE {$prefix}userinfo DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 86ALTER TABLE {$prefix}tags DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 87ALTER TABLE {$prefix}tag2post DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 88ALTER TABLE {$prefix}comments DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 89ALTER TABLE {$prefix}commentinfo DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 90ALTER TABLE {$prefix}rewrite_rules DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 91ALTER TABLE {$prefix}crontab DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 92ALTER TABLE {$prefix}log DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 93ALTER TABLE {$prefix}log_types DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 94ALTER TABLE {$prefix}groups DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 95ALTER TABLE {$prefix}users_groups DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 96ALTER TABLE {$prefix}groups_permissions DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 97ALTER TABLE {$prefix}sessions DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 98ALTER TABLE {$prefix}posts DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 99ALTER TABLE {$prefix}postinfo DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 100ALTER TABLE {$prefix}posttype DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 101ALTER TABLE {$prefix}poststatus DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 102ALTER TABLE {$prefix}options DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 103ALTER TABLE {$prefix}users DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 104ALTER TABLE {$prefix}userinfo DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 105ALTER TABLE {$prefix}tags DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 106ALTER TABLE {$prefix}tag2post DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 107ALTER TABLE {$prefix}comments DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 108ALTER TABLE {$prefix}commentinfo DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 109ALTER TABLE {$prefix}rewrite_rules DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 110ALTER TABLE {$prefix}crontab DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 111ALTER TABLE {$prefix}log DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 112ALTER TABLE {$prefix}log_types DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 113ALTER TABLE {$prefix}groups DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 114ALTER TABLE {$prefix}users_groups DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 115ALTER TABLE {$prefix}groups_permissions DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 116ALTER TABLE {$prefix}sessions DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 117 118ALTER TABLE {$prefix}posts modify column content longtext; 119ALTER TABLE {$prefix}posts modify column cached_content longtext; 120ALTER TABLE {$prefix}postinfo modify column value text; 121ALTER TABLE {$prefix}postinfo modify column value text; 122ALTER TABLE {$prefix}options modify column value text; 123ALTER TABLE {$prefix}userinfo modify column value text; 124ALTER TABLE {$prefix}comments modify column content text; 125ALTER TABLE {$prefix}commentinfo modify column value text; 126ALTER TABLE {$prefix}rewrite_rules modify column description text; 127ALTER TABLE {$prefix}crontab modify column description text; 128ALTER TABLE {$prefix}sessions modify column data mediumtext; 129