discuz mysql utf8mb4_discuzX3.4数据库改用utf8mb4字符集，实现emoji表情符

最新推荐文章于 2024-05-15 11:04:54 发布
最新推荐文章于 2024-05-15 11:04:54 发布
阅读量514 收藏 1
点赞数
文章标签： discuz mysql utf8mb4
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_32905035/article/details/113723361
版权

use bbs;

alter table pre_common_admincp_perm modify perm varchar(230) NOT NULL;

alter table pre_common_cache modify `cachekey` varchar(230) NOT NULL DEFAULT '' ;

alter table pre_common_card modify `id` char(230) NOT NULL DEFAULT '';

alter table pre_common_member_profile_setting modify `fieldid` varchar(230) NOT NULL DEFAULT '';

alter table pre_common_member_security modify `fieldid` varchar(230) NOT NULL DEFAULT '';

alter table pre_common_setting modify `skey` varchar(230) NOT NULL DEFAULT '';

alter table pre_forum_groupfield modify `type` varchar(230) NOT NULL;

alter table pre_home_favorite modify `idtype` varchar(230) NOT NULL DEFAULT '';

alter table pre_mobile_setting modify `skey` varchar(230) NOT NULL DEFAULT '';

alter table cdb_uc_badwords modify `find` varchar(230) NOT NULL DEFAULT '';

alter table pre_common_addon modify `key` varchar(230) NOT NULL DEFAULT '';

alter table pre_common_advertisement_custom modify `name` varchar(230) NOT NULL;

alter table pre_portal_topic modify `name` varchar(230) NOT NULL DEFAULT '';

ALTER DATABASE bbs CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

alter table cdb_uc_admins convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table cdb_uc_applications convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table cdb_uc_badwords convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table cdb_uc_domains convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table cdb_uc_failedlogins convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table cdb_uc_feeds convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table cdb_uc_friends convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table cdb_uc_mailqueue convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table cdb_uc_memberfields convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table cdb_uc_members convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table cdb_uc_mergemembers convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table cdb_uc_newpm convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table cdb_uc_notelist convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table cdb_uc_pm_indexes convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table cdb_uc_pm_lists convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table cdb_uc_pm_members convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table cdb_uc_pm_messages_0 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table cdb_uc_pm_messages_1 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table cdb_uc_pm_messages_2 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table cdb_uc_pm_messages_3 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table cdb_uc_pm_messages_4 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table cdb_uc_pm_messages_5 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table cdb_uc_pm_messages_6 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table cdb_uc_pm_messages_7 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table cdb_uc_pm_messages_8 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table cdb_uc_pm_messages_9 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table cdb_uc_pms convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table cdb_uc_protectedmembers convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table cdb_uc_settings convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table cdb_uc_sqlcache convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table cdb_uc_tags convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table cdb_uc_vars convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_addon convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_admincp_cmenu convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_admincp_group convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_admincp_member convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_admincp_perm convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_admincp_session convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_admingroup convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_adminnote convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_advertisement convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_advertisement_custom convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_banned convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_block convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_block_favorite convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_block_item convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_block_item_data convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_block_permission convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_block_pic convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_block_style convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_block_xml convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_cache convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_card convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_card_log convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_card_type convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_connect_guest convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_credit_log convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_credit_log_field convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_credit_rule convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_credit_rule_log convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_credit_rule_log_field convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_cron convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_devicetoken convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_district convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_diy_data convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_domain convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_failedip convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_failedlogin convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_friendlink convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_grouppm convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_invite convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_magic convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_magiclog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_mailcron convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_mailqueue convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_member convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_member_action_log convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_member_archive convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_member_connect convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_member_count convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_member_count_archive convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_member_crime convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_member_field_forum convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_member_field_forum_archive convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_member_field_home convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_member_field_home_archive convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_member_forum_buylog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_member_grouppm convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_member_log convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_member_magic convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_member_medal convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_member_newprompt convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_member_profile convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_member_profile_archive convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_member_profile_setting convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_member_security convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_member_secwhite convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_member_stat_field convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_member_stat_fieldcache convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_member_stat_search convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_member_stat_searchcache convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_member_status convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_member_status_archive convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_member_validate convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_member_verify convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_member_verify_info convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_member_wechat convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_member_wechatmp convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_moderate convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_myapp convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_myinvite convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_mytask convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_nav convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_onlinetime convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_optimizer convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_patch convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_plugin convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_pluginvar convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_process convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_regip convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_relatedlink convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_remote_port convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_report convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_searchindex convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_seccheck convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_secquestion convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_session convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_setting convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_smiley convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_sphinxcounter convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_stat convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_statuser convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_style convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_stylevar convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_syscache convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_tag convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_tagitem convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_task convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_taskvar convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_template convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_template_block convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_template_permission convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_uin_black convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_usergroup convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_usergroup_field convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_visit convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_word convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_common_word_type convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_connect_disktask convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_connect_feedlog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_connect_memberbindlog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_connect_postfeedlog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_connect_tlog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_connect_tthreadlog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_access convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_activity convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_activityapply convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_announcement convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_attachment convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_attachment_0 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_attachment_1 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_attachment_2 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_attachment_3 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_attachment_4 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_attachment_5 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_attachment_6 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_attachment_7 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_attachment_8 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_attachment_9 convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_attachment_exif convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_attachment_unused convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_attachtype convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_baidu_user convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_bbcode convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_collection convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_collectioncomment convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_collectionfollow convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_collectioninvite convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_collectionrelated convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_collectionteamworker convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_collectionthread convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_creditslog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_debate convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_debatepost convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_faq convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_filter_post convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_forum convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_forum_threadtable convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_forumfield convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_forumrecommend convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_groupcreditslog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_groupfield convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_groupinvite convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_grouplevel convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_groupranking convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_groupuser convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_hotreply_member convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_hotreply_number convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_imagetype convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_medal convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_medallog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_memberrecommend convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_moderator convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_modwork convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_newthread convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_onlinelist convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_order convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_poll convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_polloption convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_polloption_image convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_pollvoter convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_post convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_post_location convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_post_moderate convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_post_tableid convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_postcache convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_postcomment convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_postlog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_postposition convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_poststick convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_promotion convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_ratelog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_relatedthread convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_replycredit convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_rsscache convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_sofa convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_spacecache convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_statlog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_thread convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_thread_moderate convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_threadaddviews convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_threadcalendar convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_threadclass convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_threadclosed convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_threaddisablepos convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_threadhidelog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_threadhot convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_threadimage convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_threadlog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_threadmod convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_threadpartake convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_threadpreview convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_threadprofile convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_threadprofile_group convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_threadrush convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_threadtype convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_trade convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_tradecomment convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_tradelog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_typeoption convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_typeoptionvar convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_typevar convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_forum_warning convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_home_album convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_home_album_category convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_home_appcreditlog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_home_blacklist convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_home_blog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_home_blog_category convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_home_blog_moderate convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_home_blogfield convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_home_class convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_home_click convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_home_clickuser convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_home_comment convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_home_comment_moderate convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_home_docomment convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_home_doing convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_home_doing_moderate convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_home_favorite convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_home_feed convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_home_feed_app convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_home_follow convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_home_follow_feed convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_home_follow_feed_archiver convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_home_friend convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_home_friend_request convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_home_friendlog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_home_notification convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_home_pic convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_home_pic_moderate convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_home_picfield convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_home_poke convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_home_pokearchive convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_home_share convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_home_share_moderate convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_home_show convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_home_specialuser convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_home_userapp convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_home_userappfield convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_home_visitor convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_mobile_setting convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_mobile_wechat_authcode convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_mobile_wechat_masssend convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_mobile_wechat_resource convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_mobile_wsq_threadlist convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_mobileoem_member convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_mobileoem_pushthreads convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_portal_article_content convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_portal_article_count convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_portal_article_moderate convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_portal_article_related convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_portal_article_title convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_portal_article_trash convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_portal_attachment convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_portal_category convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_portal_category_permission convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_portal_comment convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_portal_comment_moderate convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_portal_rsscache convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_portal_topic convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_portal_topic_pic convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_security_evilpost convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_security_eviluser convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

alter table pre_security_failedlog convert to character set utf8mb4  COLLATE utf8mb4_general_ci;

平骧
关注
MySQL utf8mb4 字符集：支持 emoji 表情符号
记录创业路上的一些想法
05-15 8811
㈠ 序言                为了应对无线互联网的机遇和挑战、避免 emoji 表情符号带来的问题、        涉及无线相关的 MySQL 数据库建议都提前采用 utf8mb4 字符集        这必须要作为移动互联网行业的一个技术选型的要点               ㈡ 限制             需要 >= MySQL 5.5.3版本、从库也必须是5.5的了、低版本不支持
MySQL utf8mb4字符集：支持emoji表情符号
09-06 1496
MySQL utf8mb4字符集：支持emoji表情符号 ㈠ 序言 为了应对无线互联网的机遇和挑战、避免 emoji 表情符号带来的问题、 涉及无线相关的 MySQL 数据库建议都提前采用 utf8mb4 字符集 这必须要作为移动互联网行业的一个技术选型的要点 ㈡ 限制 需要 >= MySQL 5.5.3版本、从库也必须是5.5的了、低版本不支持这个字符集、复制报错 ㈢
discuz gbk 改 utf8mb4
chenji4315的博客
06-27 478
修改以下文件，将第一次出现连接库的'gbk' 改为 'utf8mb4'.每个文件只改一处。 config/config_global.php 其中 $_config['output']['charset'] = 'utf-8'; config/config_globa...
discuz mysql utf8mb4_批量将discuz数据库编码从utf8转为utf8mb4
weixin_39951930的博客
02-06 406
为获得emoji等特殊字符支持，需要将discuz的数据库编码转换为utf8mb4。确认数据库版本支持utf8mb4和utf8mb4_0900_ai_ci由于用户表中username是不重复索引，且区分大小写和声调，字符集需设置为utf8mb4_general_ci手动执行下面的SELECT CONCAT语句，然后使用执行结果替换该语句，保存为一个 sql 文件为避免 php 运行超时，请使用 c...
discuz mysql utf8mb4_discuz论坛数据库改用utf8mb4字符集，正常使用emoji表情符号的教程方案...
weixin_42099987的博客
02-05 785
官方discuzX 3.4 默认是utf8,安装后无法发一些表情符。现在做测试改成 utf8mb4.测试机环境centos 7.5mysql 8.0.11php 7.2.5apache 2.4.6一、全新安装下载补丁文件，替换加入到discuzX 3.42018.01.01官方原版文件中，即可完成安装，可以正常发表情符文件下载地址 http://bbs.wuyou.net/forum.php?...
一文搞懂字符集！ （详解utf8 、utf8mb3 和 utf8mb4 的区别，utf8mb4_unicode_ci 和 utf8mb4_general_ci的区别）
热门推荐
CharCase的博客
09-08 1万+
在学习和开发过程中偶尔会遇到乱码问题，解决问题首先想到的就是修改字符集，但又因为对字符集这个东西一知半解感觉无从下手，本文就聊聊字符集，旨在分享和学习，希望对大家有所帮助！ 文章引出字符集概念主要是为了讲解数据库utf8 、utf8mb3 和 utf8mb4 的区别，以及utf8mb4_unicode_ci 和 utf8mb4_general_ci的区别**
mysql字符集修改为utf8mb4
SongJingzhou的博客
06-20 964
ALTER TABLE `table名` CHARACTER SET = utf8mb4, convert to character set utf8mb4 collate utf8mb4_general_ci;修改mysql表的字符集为utf8mb4，防止存储表情时报错。
Discuz_X3.4_SC_UTF8【20200818】.zip
08-20
X3.4 SC_UTF8：20200818官方版本》 Discuz! X3.4 SC_UTF8【20200818】是一个深受用户喜爱的社区论坛系统，其核心在于提供稳定且功能丰富的交互平台。这个版本在2020年8月18日发布，基于UTF-8编码，确保了对多语言...
DiscuzX3.4UTF8转GBK后乱码解决方案
08-14
本文将详细介绍如何解决"DiscuzX3.4 UTF8转GBK后乱码"的问题，以及提供的资源如何使用。 首先，我们需要理解UTF-8和GBK两种编码的区别。UTF-8是一种国际标准的多字节字符编码，可以表示Unicode字符集中的所有字符，...
墨迹天气商业版UTF-8模板，Discuz3.4灰白色风格（带教程）
10-09
1.版本支持：Discuzx3.4版本，Discuzx3.3版本，DiscuzX3.2版本。包括网站首页，论坛首页，论坛列表页，论坛内容页，论坛瀑布流,资讯列表页(支持多个)，产品列表页(支持多个)，关于我们频道页。 2.模板论坛首页，...
地区表pre_common_district for MySQL_全国地区_MYSQL_
10-02
全国地区表，具体到城市、街道，数据全面，详细
Discuz_3.4_SC_UTF8
07-02
《Discuz_3.4_SC_UTF8：深度解析与应用指南》 Discuz! 是一款全球范围内广泛应用的开源社区论坛软件，由康盛创想（Comsenz）开发，其核心在于提供强大的社区构建和管理功能。本次我们将深入探讨 Discuz! 3.4 SC_UTF...
Discuz_X3.4_SC_GBK
07-02
【标签】"DISCUZ" 和 "DISCUZx3.4" 显示了这个软件是基于 Discuz! 平台的，具体是第3.4版本。Discuz! 是一个流行的开源社区建站系统，以其强大的论坛功能、丰富的插件和模板库，以及良好的社区支持而闻名。 在...
mysql 批量utf8_mysql utf8转化utf8mb4（字符集转化，批量更改为utf8mb4
weixin_28947385的博客
01-21 631
一、查看character_set 变量show variables like '%char%';'character_set_%';'collation%'; 一、character_set_client主要用来设置客户端使用的字符集。二、character_set_connection主要用来设置连接数据库时的字符集，如果程序中没有指明连接数据库使用的字符集类型则按照这个字符集设置。三、cha...
discuz mysql 缓存_升级到 MySQL 8.0+ 后Discuz! 更新缓存时出现SQL语法错误
weixin_32900811的博客
01-19 635
MySQL数据库升级到8.0+以后Discuz! 后台更新缓存时出现以下错误(1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'system>0' at line...
表字符集统一使用utf8mb4，核对规则为utf8mb4_bin
xhangs的博客
05-15 579
在 MySQL 数据库中，当提到“表字符集统一使用 utf8mb4，核对规则为 utf8mb4_bin”的时候，意思涉及到字符集和核对规则（collation）的设置。在实际应用中，如果你的 MySQL 数据库表需要处理多语言数据，特别是包含表情符号或特殊字符的数据，推荐使用。这样可以确保数据的准确存储和正确比较。
MySQL的utf8编码和utf8mb4
u014294083的博客
03-03 371
mysql的utf8编码最多支持3个字节，utf8mb4编码可以支持4个字节，utf8编码能够支持的字符集是utf8mb4编码的子集（例如：utf8mb4编码可以支持emoji表情，而utf8不支持） 若当前的数据库、表和字段已经设置为了utf8编码，那么当需要处理生僻字符（4字节）时，需要将编码更新为utf8mb4，经过验证一下过程可以实现： 修改数据库编码及字符集 ALTER DATABASE db_name(你的数据库) CHARACTER SET = utf8mb4 COLLATE = utf8
Mysql 批量更改数据表和字段的字符集（Mysql UTF-8字符集更改为utf8mb4字符集）
Jarvis.y的博客
10-13 1747
由于Mysql的utf8是有缺陷的，不是真正的UTF-8，utf8mb4才是真正的UTF-8。当你的生产项目一不小心使用到了UTF-8的时候，就需要下面命令去解决问题了。 1、更改表编码(字符集)和表中所有字段的编码(字符集) ALTER TABLE TABLE_NAME CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; 2、查询某个数据库所有表名的语句 SELECT TABLE_NAME from information_schem
5116-微信小程序电影院订票选座系统设计及实现+ssm（源码+数据库+lun文）.zip
最新发布
09-15
本系统主要针对计算机相关专业的正在做毕业设计的学生和需要项目实战练习的学习者，可作为毕业设计、课程设计、期末大作业。本系统主要针对计算机相关专业的正在做毕业设计的学生和需要项目实战练习的学习者，可作为毕业设计、课程设计、期末大作业。本系统主要针对计算机相关专业的正在做毕业设计的学生和需要项目实战练习的学习者，可作为毕业设计、课程设计、期末大作业。本系统主要针对计算机相关专业的正在做毕业设计的学生和需要项目实战练习的学习者，可作为毕业设计、课程设计、期末大作业。
DiscuzX X3.4 添加自定义道具步骤详解
"这是一个关于在DiscuzX X3.4版本中添加新道具的详细教程，由作者原创并经过测试成功，适用于PHP论坛环境，旨在帮助用户理解如何自定义和管理论坛道具。" 在DiscuzX论坛系统中，道具是增强用户互动性和趣味性的重要...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值