I've tried using a stored procedure to create indices, and got the following error:
ERROR 1267 (HY000): Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='
There's no line number or any other debugging hint.
- What's the best way to debug this error?
- Are there any good guidelines to avoid encoding inconsistencies?