---数据库字符集


服务器本身的的这个属性:
show variables like 'collation_%';
show variables like 'character_set_%';
方法一:show variables like '%character%';
方法二:show variables like 'collation%';

查看支持的字符集:
show charset;

show table status from class_7 like 'test_info';
 show table status from myblog like 'wp_posts';   #特定表
 show table status from myblog ;   #全部表


我大概看了一下子我wordpress 库表, 放心了! 
utf8mb4_unicode_ci

设置字符集:

alter database 库名 default character set 字符集;

 ref:
https://www.cnblogs.com/yangmingxianshen/p/7999428.html
https://www.jb51.net/article/135715.htm

https://www.cnblogs.com/jpfss/p/7881836.html



posted on 2019-12-16 21:06  linuxdog  阅读(322)  评论(0编辑  收藏  举报

导航