1 Matlab 通過(guò) odbc 數(shù)據(jù)源連接 mysql 數(shù)據(jù)庫(kù)彤悔，并解決數(shù)據(jù)中文亂碼
upgraded mysql odbc connector: https://dev.mysql.com/downloads/file/?id=472464
-
control panel - data source(odbc) - user DSN - add - mysql odbc 5.3 Unicode driver
*** on 'mysql conector/odbc data source configuration' panel - details, remember to:
(1) check 'interactive client'
(2) set 'character set': GBK
- in MATLAB:
slCharacterEncoding('GBK);
conn = database(datasource, username, pswd);
curs = exec(conn, querystatement);
curs = fetch(curs, 5);
data = curs.data
- bingo.
利用matlab DataExplorer 打開(kāi)數(shù)據(jù)庫(kù)嫉你，可以發(fā)現(xiàn)中文顯示正常
參考文獻(xiàn)：
解決方法：金鳥(niǎo)兒 https://blog.csdn.net/goyyue/article/details/78835635
字符編碼介紹見(jiàn)：http://www.reibang.com/p/c23f3ea5443d
2 解決 sql文件太大無(wú)法導(dǎo)入的問(wèn)題
如@kakuilan 所說(shuō), 在my.cnf中把max_allowed_packet改大點(diǎn)即可.
我在的環(huán)境是docker MySQL5.7,
使用mysql命令行輸入:
set global max_allowed_packet = 200*1024*1024
show VARIABLES LIKE '%max_allowed_packet%';
參考文獻(xiàn)：
解決方法見(jiàn)：https://github.com/kakuilan/china_area_mysql/issues/11
