《Mysql應(yīng)用查看mysql默認(rèn)編碼二種方法》要點(diǎn)：
本文介紹了Mysql應(yīng)用查看mysql默認(rèn)編碼二種方法，希望對(duì)您有用。如果有疑問(wèn)，可以聯(lián)系我們。
導(dǎo)讀：本節(jié)內(nèi)容：如何查看mysql數(shù)據(jù)庫(kù)的默認(rèn)編碼方法1、使用status命令能夠顯示數(shù)據(jù)庫(kù)的相關(guān)系信息
mysql> status;————–mysql ver 14...
MYSQL實(shí)例本節(jié)內(nèi)容：
如何查看mysql數(shù)據(jù)庫(kù)的默認(rèn)編碼
?
方法1、使用status命令能夠顯示數(shù)據(jù)庫(kù)的相關(guān)系信息
?
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實(shí)例方法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應(yīng)用查看mysql默認(rèn)編碼二種方法》討論，分享您的想法，維易PHP學(xué)院為您提供專業(yè)教程。
轉(zhuǎn)載請(qǐng)注明本頁(yè)網(wǎng)址：
http://www.snjht.com/jiaocheng/7445.html
