Database mismatched collation sequences

parallaxinc / BlocklyProp

Blockly based visual programming editor for Propeller C

MIT License

44 stars 24 forks source link

Database mismatched collation sequences #1112

Open zfi opened 7 years ago

zfi commented 7 years ago

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 commented 7 years ago

It appears that the blocklyprop database default character set is 'utf8'. The default table collation is 'utf8_general_ci'.

The cloudsession database default character set is 'latin1' and the default table collation is 'latin1_swedish_ci'.