Illegal mix of collations

This error occurs when columns compared in the same query use different collations. The fix is to make the related columns use the same collation.

QB / QBOX users

QB and QBOX servers use the players.citizenid column.

What to do

Change the collation of the citizenid column in the players table.

Target collation:

utf8mb4_unicode_ci

SQL

ALTER TABLE players
  MODIFY citizenid VARCHAR(11)
  CHARACTER SET utf8mb4
  COLLATE utf8mb4_unicode_ci;

---

ESX users

ESX servers use the users.identifier column.

What to do

Change the collation of the identifier column in the users table.

Target collation:

utf8mb3_general_ci

SQL

ALTER TABLE users
  MODIFY identifier VARCHAR(60)
  CHARACTER SET utf8mb4
  COLLATE utf8mb3_general_ci;

---

Notes

• You can also change the collation manually via HeidiSQL or phpMyAdmin.

• A server restart is recommended after applying the change.

• No script changes are required.

---

Example error logs

Illegal mix of collations (utf8mb4_general_ci,IMPLICIT)
and (utf8mb4_unicode_ci,IMPLICIT) for operation '='

---

If you want, I can also provide:

• a one-line TL;DR version

• or a bulk SQL script to normalize all related tables at once