《Mysql應用查看mysql默認編碼二種方法》要點：
本文介紹了Mysql應用查看mysql默認編碼二種方法，希望對您有用。如果有疑問，可以聯系我們。
導讀：本節內容：如何查看mysql數據庫的默認編碼方法1、使用status命令能夠顯示數據庫的相關系信息
mysql> status;————–mysql ver 14...
MYSQL實例本節內容：
如何查看mysql數據庫的默認編碼
?
方法1、使用status命令能夠顯示數據庫的相關系信息
?
mysql> status;
————–
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編碼
?
mysql> show variables like’char%’;
+————————–+——————————————–+
| 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學院為您提供專業教程。
轉載請注明本頁網址：
http://www.fzlkiss.com/jiaocheng/7445.html
