org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [select * from USERLOGIN where LOGINID = ? ]; SQL state [HY000]; error code [1267]; Illegal mix of collations (gb2312_chinese_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='; nested exception is java.sql.SQLException: Illegal mix of collations (gb2312_chinese_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='
请问引发次异常是什么原因引起?高手帮忙下?
java.sql.SQLException: Illegal mix of collations (gb2312_chinese_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='这个代表什么?
------解决方法--------------------------------------------------------
从错误中,可以看到是字符引起的
Illegal mix of collations (gb2312_chinese_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE)
找到其中的SQL语句,把gb2312换成utf8实验下.