SQL errors : Illegal mix of collations for operation 'in'

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • op2
    Member
    • Nov 2008
    • 76
    • 5.3.x

    SQL errors : Illegal mix of collations for operation 'in'

    Hi
    Since the migration from V4 to V5 we got a lot of errors like this :

    Database error in vBulletin 5.3.2:

    Invalid SQL:
    SELECT * FROM routenew
    WHERE `prefix` IN ('installation-et-mise-� -jour-/favicon.ico',installation-et-mise-� -jour' ... );

    MySQL Error : Illegal mix of collations for operation 'in'
    Error Number : 1271

    We have tried many settings without success.Could you please tell me how to fix this.
    Thanks
    French Joomla forum : https://forum.joomla.fr
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...