By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
utf8_col | charset | collation | concat1 | charset_concat1 |
---|---|---|---|---|
ã | utf8 | utf8_bin | ãñ | utf8 |
Illegal mix of collations (utf8_bin,IMPLICIT) and (utf8mb4_0900_ai_ci,COERCIBLE) for operation 'concat'
utf8_col < _utf8mb4'ñ' |
---|
1 |
Illegal mix of collations (utf8_bin,IMPLICIT) and (utf8mb4_0900_ai_ci,COERCIBLE) for operation '<'