問題描述

問題如下：mac 系統(tǒng)版本 10.12.2 mysql 數(shù)據(jù)版本 5.6.35-macos10.12-x86_64

現(xiàn)在已經(jīng)在／etc／my.cnf 中添加utf8編碼

# 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] 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 = .....# socket = .....[client] default-character-set=utf8

終端查詢字符編碼如下：

終端查詢中已經(jīng)設(shè)置成為utf8 編碼

navicat 中查詢

終端查詢帶有中文的數(shù)據(jù)表

IDE 中 java 查詢數(shù)據(jù)表

現(xiàn)在問題是 能在navicat 中能夠查詢中文。 在mac終端和java中查詢都是亂碼。 ，求解決。。。。。。。

問題解答

已經(jīng)找到問題所在，就是因?yàn)樵趎avicat批量導(dǎo)入sql文件得的時候，mac系統(tǒng)中的navicat會自動把編碼變?yōu)閐efault(latin1) ，所以在navicat中看到是正常的中文，而由于在mac終端以及java 設(shè)置的編碼都是utf8，所以就產(chǎn)生了亂碼。以后導(dǎo)入sql數(shù)據(jù)時候需要注意一下！！！