《Mysql學習查看mysql數據庫默認編碼的方法》要點：
本文介紹了Mysql學習查看mysql數據庫默認編碼的方法，希望對您有用。如果有疑問，可以聯系我們。
導讀：查看mysql數據庫的默認編碼,有以下兩種方法.1、使用status命令顯示數據庫編碼信息
mysql> status;————–mysql ver 14.12 dis...
MYSQL實例查看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.jbxue.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命令顯示數據庫編碼
?
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)
維易PHP培訓學院每天發布《Mysql學習查看mysql數據庫默認編碼的方法》等實戰技能，PHP、MYSQL、LINUX、APP、JS,CSS全面培養人才。
轉載請注明本頁網址：
http://www.snjht.com/jiaocheng/7439.html
