Конвертирование базы в UTF-8

[Osetin]

По умолчанию на MySQL стоит кодировка latin1. Нам ее не нужно, поэтому надо перекодировать базу.

Используем следующий запрос для получения списка таблиц:

SELECT CONCAT('ALTER TABLE `', t.`TABLE_SCHEMA`, '`.`', t.`TABLE_NAME`, '` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;') as sqlcode
FROM `information_schema`.`TABLES` t
WHERE 1
AND t.`TABLE_SCHEMA` = 'имя_базы'
ORDER BY 1
После этого копируем сформировавшийся список в документ, он выглядит примерно так (это пример для VBulletin):

ALTER TABLE `имя_базы`.`access` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`action` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`activitystreamtype` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`activitystream` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`adcriteria` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`adminhelp` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`administrator` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`adminlog` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`adminmessage` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`adminutil` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`ad` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`albumupdate` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`album` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`announcementread` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`announcement` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`apiclient` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`apilog` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`apipost` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`attachmentcategoryuser` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`attachmentcategory` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`attachmentpermission` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`attachmenttype` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`attachmentviews` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`attachment` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`autosave` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`avatar` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`bbcode_video` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`bbcode` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`blockconfig` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`blocktype` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`block` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`bookmarksite` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`cacheevent` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`cache` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`calendarcustomfield` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`calendarmoderator` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`calendarpermission` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`calendar` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`contentpriority` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`contentread` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`contenttype` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`cpsession` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`cronlog` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`cron` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`customavatar` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`customprofilepic` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`customprofile` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`datastore` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`dbquery` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`deletionlog` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`discussionread` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`discussion` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`editlog` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`event` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`externalcache` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`faq` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`filedata` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`forumpermission` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`forumprefixset` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`forumread` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`forumrunner_push_data` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`forumrunner_push_users` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`forum` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`groupmessage_hash` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`groupmessage` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`groupread` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`holiday` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`humanverify` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`hvanswer` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`hvquestion` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`icon` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`imagecategorypermission` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`imagecategory` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`indexqueue` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`infractionban` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`infractiongroup` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`infractionlevel` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`infraction` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`ipdata` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`language` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`mailqueue` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`moderation` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`moderatorlog` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`moderator` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`navigation` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`noticecriteria` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`noticedismissed` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`notice` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`package` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`passwordhistory` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`paymentapi` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`paymentinfo` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`paymenttransaction` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`phrasetype` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`phrase` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`picturecomment_hash` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`picturecomment` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`picturelegacy` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`plugin` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`pmreceipt` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`pmtext` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`pmthrottle` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`pm` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`podcastitem` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`podcast` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`pollvote` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`poll` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`postedithistory` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`posthash` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`postlog` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`postparsed` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`postrelease` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`post_thanks` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`post` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`prefixpermission` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`prefixset` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`prefix` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`productcode` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`productdependency` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`product` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`profileblockprivacy` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`profilefieldcategory` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`profilefield` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`profilevisitor` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`ranks` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`reminder` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`reputationlevel` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`reputation` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`route` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`rssfeed` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`rsslog` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`searchcore_text` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`searchcore` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`searchgroup_text` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`searchgroup` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`searchlog` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`session` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`settinggroup` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`setting` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`sigparsed` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`sigpic` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`skimlinks` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`smilie` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`socialgroupcategory` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`socialgroupicon` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`socialgroupmember` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`socialgroup` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`spamlog` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`stats` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`strikes` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`stylevardfn` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`stylevar` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`style` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`subscribediscussion` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`subscribeevent` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`subscribeforum` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`subscribegroup` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`subscribethread` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`subscriptionlog` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`subscriptionpermission` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`subscription` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`tachyforumcounter` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`tachyforumpost` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`tachythreadcounter` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`tachythreadpost` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`tagcontent` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`tagsearch` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`tag` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`templatehistory` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`templatemerge` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`template` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`threadrate` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`threadread` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`threadredirect` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`threadviews` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`thread` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`upgradelog` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`useractivation` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`userban` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`userchangelog` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`usercsscache` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`usercss` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`userfield` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`usergroupleader` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`usergrouprequest` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`usergroup` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`userlist` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`usernote` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`userpromotion` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`usertextfield` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`usertitle` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`user` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`visitormessage_hash` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`visitormessage` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`vsavilxh_guests` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `имя_базы`.`vsa_chatbox` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
Осталось вставить этот запрос в базу и конвертнуть таблицы.