Illegal mix of collations

Forum for questions and support relating to the 1.30.x releases only.
Locked
Sigge
Posts: 116
Joined: Mon May 02, 2016 8:14 am

Illegal mix of collations

Post by Sigge »

Updated from 1.30.0 to 1.30.4 on ubuntu 17.04

Got this as response in browser after login:

SQL-ERR 'SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='', statement was 'select * from Users where Enabled = 1 AND Username=? AND Password=password(?)'

What does it mean?
Sigge
Posts: 116
Joined: Mon May 02, 2016 8:14 am

Re: Illegal mix of collations

Post by Sigge »

Sorry, found the solution:

Change Mariadb settings:

nano /etc/mysql/my.cnf

Make the following changes:

character-set-server = latin1
collation-server = latin1_swedish_ci
Locked