In this case you should provide explicit collation to the column your are casting (most probably, you want to cast latin1 to UTF8), and this should be the collation of the column you are casting to:SELECT *FROM utf_tableJOIN latin_tableON utf_column = latin_column COLLATE UTF8_GENERAL_CI 这篇关于UTF-8 vs Latin1 mysql,未在utf-8上使用的索引的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持! 上岸,阿里云! 08-07 10:11