Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.1.35
-
None
-
Debian
Description
latin1 is a subset of utf8 so the comparison is well defined.
CREATE TABLE `t` (
|
`a` varchar(255) CHARACTER SET latin1 NOT NULL
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|
|
|
SELECT * FROM t WHERE a = 'ā';
|
|
|
// ERROR 1267 (HY000): Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='
|