cakephp : Illegal mix of collations (tis620_thai_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='

i got

 SQL Error: 1267: Illegal mix of collations (tis620_thai_ci,IMPLICIT) and    (latin1_swedish_ci,COERCIBLE) f开发者_Go百科or operation '='

when i insert non english to form

how to fix or hide the problem Thank you for any advice

You're receiving the error because you have the collation in your Mysql set to latin1. You'll need to modify the collation of your tables (and possibly fields) to be tis620 and that should resolve the problem.