high
confirmed
oxmysql / database · AGN-KB-DB-0004
Illegal mix of collations in a query
The message
Illegal mix of collations
Two parts of AGN's database describe text slightly differently, so a lookup between them failed. Server-side only.
What you see
- One specific query or feature fails while everything else works
- Usually appears the first time a new table is joined to an old one
What usually causes it
- Two tables created with different collations are being joined on a text column
- AGN's newer tables are utf8mb4_unicode_ci while qb-core's players table is utf8mb4_general_ci, so a join on citizenid throws
Worth checking first
- Identify both tables in the join
- Compare their column collations
Safe steps, one at a time
- Player-side: nothing; report the feature that failed
- Staff: align the collation on the joining column, or cast explicitly in the query — do not convert an entire live table casually
These are suggestions, not instructions. Do only what you are comfortable with, back up anything important first, and stop if a step does not match what is on your screen. Advice, risk and responsibility.
When to stop and ask staff
Staff.
Looks like
AGN server
What staff will need
- Exact error
- The feature that triggered it
- Both table names if known
Applies to
MariaDB 10.4.
Last reviewed Fri Sep 18.