The database is set to use the collation "latin1_swedish_ci", while the tables are all set to use "utf8_general_ci". This causes problems when you're trying to use computed columns, since they'll be using the database's collation.
Fix would be to set the database's collation to "utf8_general_ci"
Version: unspecified
Severity: normal
It errors out with Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,NUMERIC) for operation '>'
Done:
> show variables like "character_set_database"; +------------------------+-------+ | Variable_name | Value | +------------------------+-------+ | character_set_database | utf8 | +------------------------+-------+ 1 row in set (0.00 sec) > show variables like "collation_database"; +--------------------+-----------------+ | Variable_name | Value | +--------------------+-----------------+ | collation_database | utf8_general_ci | +--------------------+-----------------+ 1 row in set (0.01 sec)