在mysql 4.1.8里执行左连接出错
在mysql 4.1.8里执行左连接出错.php版本是4.3
在版本mysql4.0,php 4.0.3执行就没问题.
sql语句:SELECT c_9.red, c_9.id, c_9.price_jzk, c_9.price_jqt
FROM c_9 LEFT JOIN c_4 ON c_9.khxm = c_4.khxm ORDER BY to_days( c_4.q_date ) DESC
LIMIT 0 , 30
错误提示:
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_bin,IMPLICIT) for operation '='