Mysql应用查看mysql默认编码二种方法
发布时间:2020-12-12 03:05:53 所属栏目:MySql教程 来源:网络整理
导读:《Mysql应用查看mysql默认编码二种方法》要点: 本文介绍了Mysql应用查看mysql默认编码二种方法,希望对您有用。如果有疑问,可以联系我们。 导读:本节内容:如何查看mysql数据库的默认编码方法1、使用status命令能够显示数据库的相关系信息mysql status;—
《Mysql应用查看mysql默认编码二种方法》要点: MYSQL实例本节内容: ————– mysql ver 14.12 distrib 5.0.77,for win32 (ia32) ? connection id:????????? 1072 current database: current user:?????????? test@119.119.247.6 ssl:??????????????????? not in use using delimiter:??????? ; server version:???????? 5.0.67-log mysql community server (gpl) protocol version:?????? 10 connection:???????????? www.chinajvm.com via tcp/ip server characterset:??? gbk db???? characterset:??? gbk client characterset:??? latin1 conn. characterset:??? latin1 tcp port:?????????????? 3306 uptime:???????????????? 15 days 2 hours 21 min 37 sec ? MYSQL实例方法2、使用show variables like’char%’;命令查看mysql编码 +————————–+——————————————–+ | variable_name??????????? | value????????????????????????????????????? | +————————–+——————————————–+ | character_set_client???? | latin1???????????????????????????????????? | | character_set_connection | latin1???????????????????????????????????? | | character_set_database | gbk??????????????????????????????????????? | | character_set_filesystem | binary???????????????????????????????????? | | character_set_results??? | latin1???????????????????????????????????? | | character_set_server???? | gbk??????????????????????????????????????? | | character_set_system???? | utf8?????????????????????????????????????? | | character_sets_dir?????? | /mysql/mastermysql50/share/mysql/charsets/ | +————————–+——————————————–+ 8 rows in set (0.03 sec) 欢迎参与《Mysql应用查看mysql默认编码二种方法》讨论,分享您的想法,编程之家PHP学院为您提供专业教程。 (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |