有人知道这个异常怎么解决吗
异常信息:
java.sql.SQLException: Illegal mix of collations (gb2312_chinese_ci,IMPLICIT) and (gbk_chinese_ci,COERCIBLE) for operation 'like'
源码:
select * from channel where channel_status>=0 and channel_name like ?
ps.setString(i++,"%"+channelCondition.getChannelName().trim()+"%");
有人知道这个异常怎么解决吗?