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

最新推荐文章于 2023-06-20 19:21:12 发布
最新推荐文章于 2023-06-20 19:21:12 发布
阅读量506 收藏 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;

平骧
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
discuz3.4 数据库表注释
痛并快乐着
01-16 1419
pre_common_addon 插件扩展中心服务商表 pre_common_admincp_cmenu 后台管理面板，自定义常用菜单表 pre_common_admincp_group 后台团队职务名称表 pre_common_admincp_member 后台管理员成员表 pre_common_admincp_perm 后台团队职务权限分配表 pre_common_admincp_sessio...
discuz X3数据库表结构
cruel的专栏
08-19 8066
pre_common_addon 插件扩展中心服务商表    pre_common_admincp_cmenu 后台管理面板，自定义常用菜单表    pre_common_admincp_group 后台团队职务名称表    pre_common_admincp_member 后台管理员成员表    pre_common_admincp_perm 后台团队职务权限分配表
discuz mysql utf8mb4_discuz论坛数据库改用utf8mb4字符集，正常使用emoji表情符号的教程方案...
weixin_42099987的博客
02-05 773
官方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?...
mysql字符集修改为utf8mb4
SongJingzhou的博客
06-20 930
ALTER TABLE `table名` CHARACTER SET = utf8mb4, convert to character set utf8mb4 collate utf8mb4_general_ci;修改mysql表的字符集为utf8mb4，防止存储表情时报错。
解决mysql表或这字段字符集不一致错误
o12321o的博客
01-20 1272
解决mysql表或这字段字符集不一致错误报错内容解决方式 报错内容 java.sql.SQLException: Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation ‘=’ 解决方式 1、首先找到相关表，查看表字符集是否一致 show table status from 数据库名称 like 表名; 2、查看字段是否一致 SHOW FULL COLUM
MySQL数据库utf8升级utf8mb4的步骤
qq_40006446的博客
05-30 2650
utf8升级utf8mb4具体步骤：首先将我们数据库默认字符集由utf8更改为utf8mb4，然后将表默认字符集也更改为utf8mb4，最后再把存储表情的字段默认字符集也做相应的调整。MySQL数据库utf8升级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.模板论坛首页，...
Discuz x3.4手机模板 淘宝客 导购 仿天猫 商业版 GBK+UTF8.zip
12-03
《Discuz x3.4手机模板：淘宝客与导购网站的商业版实现》 Discuz x3.4是一款广泛应用于论坛、社区等互动平台的开源软件，它以其强大的功能和高度的可定制性赢得了广大用户的青睐。本次我们关注的是专为手机用户设计...
Discuz_3.4_SC_UTF8
07-02
《Discuz_3.4_SC_UTF8：深度解析与应用指南》 Discuz! 是一款全球范围内广泛应用的开源社区论坛软件，由康盛创想（Comsenz）开发，其核心在于提供强大的社区构建和管理功能。本次我们将深入探讨 Discuz! 3.4 SC_UTF...
地区表pre_common_district for MySQL_全国地区_MYSQL_
10-02
全国地区表，具体到城市、街道，数据全面，详细
mysql 批量utf8_mysql utf8转化utf8mb4（字符集转化，批量更改为utf8mb4
weixin_28947385的博客
01-21 601
一、查看character_set 变量show variables like '%char%';'character_set_%';'collation%'; 一、character_set_client主要用来设置客户端使用的字符集。二、character_set_connection主要用来设置连接数据库时的字符集，如果程序中没有指明连接数据库使用的字符集类型则按照这个字符集设置。三、cha...
mysql统计某个库中所有的表的行数
welisa的博客
05-11 726
查看整个库的所有表； mysql> select a.TABLE_NAME,a.TABLE_ROWS from TABLES as a where TABLE_SCHEMA = 'ultrax' order by TABLE_ROWS desc; +-----------------------------------+------------+ | TABLE_NAME | TABLE_ROWS | +--------------------------...
discuz mysql utf8mb4_批量将discuz数据库编码从utf8转为utf8mb4
weixin_39951930的博客
02-06 377
为获得emoji等特殊字符支持，需要将discuz的数据库编码转换为utf8mb4。确认数据库版本支持utf8mb4和utf8mb4_0900_ai_ci由于用户表中username是不重复索引，且区分大小写和声调，字符集需设置为utf8mb4_general_ci手动执行下面的SELECT CONCAT语句，然后使用执行结果替换该语句，保存为一个 sql 文件为避免 php 运行超时，请使用 c...
mysql字符集的查看、修改、踩坑
个人网站：https://www.longzipeng.online
11-24 1334
mysql字符集的查看、修改、踩坑，批量修改表字符集，同时修改表和表中字段的字符集
Mysql插入中文字符错误解决方案
u012321968的博客
09-25 438
在my.cnf中添加如下内容 [client] default-character-set=utf8mb4 [mysqld] character-set-server = utf8mb4 collation-server = utf8mb4_unicode_ci init_connect='SET NAMES utf8mb4' skip-character-set-client-handshake = true [mysql] default-character-
java 微信群发多图文_java微信接口之五—消息分组群发
weixin_35683614的博客
02-13 291
一、微信消息分组群发接口简介1、请求：该请求是使用post提交地址为：https://api.weixin.qq.com/cgi-bin/message/mass/sendall?access_token=ACCESS_TOKEN其中ACCESS_TOKEN是我们动态获取的。发送的数据：(这里使用图文消息示例){"filter":{"group_id":"2"},"mpnews":{"media_...
discuz论坛支持emoji表情修改教程！
zifeiyuok的博客
09-02 871
这里将以修改“全新安装”版本的方式来做例子，可以到 Discuz 官网下载最新安装包， 要将 Discuz 编码修改成 utf8mb4 其实不难，不过要花上一些时间， 最重要的是 MySQL 的版本最低需求 5.5.3 才支持 utf8mb4 编码。
怎么在linux deepin版本中完成以下任务 LNMP,LAMP架构搭建 1.安装apache，nginx 2.安装mysql 3.安装PHP和插件 4.配置apache, nginx, mysql（mysql内放一些数据） 5.安装discuz论坛 6.测试
06-10
在Linux Deepin版本中搭建LNMP或LAMP架构，可以按照以下步骤进行： 1. 安装apache和nginx - 安装Apache：在终端中输入以下命令： ``` sudo apt-get update sudo apt-get install apache2 ``` - 安装Nginx：在终端中输入以下命令： ``` sudo apt-get update sudo apt-get install nginx ``` 2. 安装MySQL 在终端中输入以下命令： ``` sudo apt-get update sudo apt-get install mysql-server ``` 安装过程中会提示您设置MySQL的root账户密码，记得设置一个强密码。 3. 安装PHP和插件 在终端中输入以下命令： ``` sudo apt-get update sudo apt-get install php php-mysql php-curl php-gd php-xml php-mbstring ``` 4. 配置Apache、Nginx、MySQL - 配置Apache：在终端中输入以下命令打开Apache的配置文件： ``` sudo nano /etc/apache2/apache2.conf ``` 在文件末尾添加以下内容： ``` <Directory /var/www/html/> Options Indexes FollowSymLinks AllowOverride All Require all granted </Directory> ``` 保存并关闭文件，然后重新启动Apache： ``` sudo service apache2 restart ``` - 配置Nginx：在终端中输入以下命令打开Nginx的配置文件： ``` sudo nano /etc/nginx/sites-available/default ``` 修改其中的server部分，添加以下内容： ``` location / { try_files $uri $uri/ /index.php$is_args$args; } location ~ \.php$ { include fastcgi_params; fastcgi_pass unix:/var/run/php/php7.0-fpm.sock; fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name; fastcgi_param PATH_INFO $fastcgi_path_info; } ``` 修改完成后保存并关闭文件，然后重新启动Nginx： ``` sudo service nginx restart ``` - 配置MySQL：在终端中输入以下命令进入MySQL： ``` mysql -u root -p ``` 然后输入您设置的root账户密码进行登录。接着创建一个新的MySQL用户并为其授权： ``` CREATE USER 'discuz'@'localhost' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON *.* TO 'discuz'@'localhost' WITH GRANT OPTION; FLUSH PRIVILEGES; ``` 这里创建了一个名为discuz的MySQL用户，并为其设置了一个密码password。您也可以根据需要进行修改。 5. 安装Discuz论坛 在终端中输入以下命令下载Discuz论坛的压缩包： ``` wget http://download.comsenz.com/DiscuzX/3.4/Discuz_X3.4_SC_UTF8.zip ``` 下载完成后解压缩： ``` unzip Discuz_X3.4_SC_UTF8.zip ``` 将解压缩后的文件复制到Apache或Nginx的根目录： ``` sudo cp -r upload/* /var/www/html/ ``` 6. 测试 打开浏览器，访问http://localhost/，如果您看到Discuz论坛的首页，说明您已经成功搭建了LNMP或LAMP架构。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值