BlocklyProp icon indicating copy to clipboard operation
BlocklyProp copied to clipboard

Database mismatched collation sequences

Open zfi opened this issue 7 years ago • 1 comments

Database contains tables with different and incompatible collation settings. Update SQL statements that create tables to always supply a collation specification. Never rely on the database default.

OperationalError: (_mysql_exceptions.OperationalError) (1267, "Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='")

zfi avatar Jul 24 '17 15:07 zfi