《Mysql學(xué)習(xí)MySQL綠色版設(shè)置編碼以及1067錯(cuò)誤詳解》要點(diǎn)：
本文介紹了Mysql學(xué)習(xí)MySQL綠色版設(shè)置編碼以及1067錯(cuò)誤詳解，希望對(duì)您有用。如果有疑問，可以聯(lián)系我們。

MySQL綠色版設(shè)置編碼,以及1067錯(cuò)誤MYSQL教程

查看MySQL編碼MYSQL教程

SHOW VARIABLES LIKE 'char%';

因?yàn)楫?dāng)初安裝時(shí)指定了字符集為UTF8,所以所有的編碼都是UTF8.MYSQL教程

• character_set_client：你發(fā)送的數(shù)據(jù)必須與client指定的編碼一致!!!服務(wù)器會(huì)使用該編碼來解讀客戶端發(fā)送過來的數(shù)據(jù)；
• character_set_connection：通過該編碼與client一致!該編碼不會(huì)導(dǎo)致亂碼!當(dāng)執(zhí)行的是查詢語句時(shí),客戶端發(fā)送過來的數(shù)據(jù)會(huì)先轉(zhuǎn)換成connection指定的編碼.但只要客戶端發(fā)送過來的數(shù)據(jù)與client指定的編碼一致,那么轉(zhuǎn)換就不會(huì)出現(xiàn)問題；
• character_set_database：數(shù)據(jù)庫默認(rèn)編碼,在創(chuàng)建數(shù)據(jù)庫時(shí),如果沒有指定編碼,那么默認(rèn)使用database編碼；
• character_set_server：MySQL服務(wù)器默認(rèn)編碼；
• character_set_results：響應(yīng)的編碼,即查詢結(jié)果返回給客戶端的編碼.這說明客戶端必須使用result指定的編碼來解碼；

修改character_set_client、character_set_results、character_set_connection為GBK,
就不會(huì)出現(xiàn)亂碼了.但其實(shí)只需要修改character_set_client和character_set_results.

控制臺(tái)的編碼只能是GBK,而不能修改為UTF8,這就出現(xiàn)一個(gè)問題.客戶端發(fā)送的數(shù)據(jù)是GBK,而character_set_client為UTF8,這就說明客戶端數(shù)據(jù)到了服務(wù)器端后一定會(huì)出現(xiàn)亂碼.既然不能修改控制臺(tái)的編碼,那么只能修改character_set_client為GBK了.
MYSQL教程

服務(wù)器發(fā)送給客戶端的數(shù)據(jù)編碼為character_set_result,它如果是UTF8,那么控制臺(tái)使用GBK解碼也一定會(huì)出現(xiàn)亂碼.因?yàn)闊o法修改控制臺(tái)編碼,所以只能把character_set_result修改為GBK.
填上這句話：MYSQL教程

MYSQL教程

下面是整體配置：MYSQL教程

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.
[mysqld]
basedir = H:\MySQL
datadir = H:\MySQL\data
character_set_server = utf8 
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
# These are commonly set, remove the # and set as required.
# basedir = .....
# datadir = .....
# port = .....
# server_id = .....
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M 
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 
[client]
port=3306
default-character-set = gbk

1067錯(cuò)誤MYSQL教程

注意my.ini里面的配置不要寫錯(cuò)了,其實(shí)我們很多出現(xiàn)1067錯(cuò)誤的都是my.ini里面配錯(cuò)了.MYSQL教程

備注：MYSQL教程

在windows10中,其實(shí)設(shè)置default-character-set = utf8,然后在cmd中進(jìn)行操作也不會(huì)亂碼.但是在windows8.1、windows7中就會(huì)亂碼.所以在windows8.1、windows7中必須把default-character-set = gbk 設(shè)置為gbkMYSQL教程

感謝閱讀,希望能贊助到大家,謝謝大家對(duì)本站的支持!MYSQL教程

歡迎參與《Mysql學(xué)習(xí)MySQL綠色版設(shè)置編碼以及1067錯(cuò)誤詳解》討論，分享您的想法，維易PHP學(xué)院為您提供專業(yè)教程。

轉(zhuǎn)載請(qǐng)注明本頁網(wǎng)址：
http://www.fzlkiss.com/jiaocheng/12008.html