Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.5, 10.6, 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.7(EOL), 10.8(EOL), 10.9(EOL)
-
None
Description
CREATE OR REPLACE TABLE t1 (a CHAR(10)) CHARACTER SET utf8mb4 COLLATE DEFAULT; |
SHOW CREATE TABLE t1; |
+-------+----------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+----------------------------------------------------------------------------------------+
|
| t1 | CREATE TABLE `t1` (
|
`a` char(10) DEFAULT NULL
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
|
+-------+----------------------------------------------------------------------------------------+
|
The column was created with a wrong character set. The expected character set is utf8mb4.
Attachments
Issue Links
- relates to
-
MDEV-27009 Add UCA-14.0.0 collations
- Closed
-
MDEV-28067 Multiple conflicting column COLLATE clauses are not rejected
- Closed
-
MDEV-27690 Crash on `CHARACTER SET csname COLLATE DEFAULT` in column definition
- Closed
-
MDEV-27743 Remove Lex::charset
- Closed
-
MDEV-27853 Wrong data type on column `COLLATE DEFAULT` and table `COLLATE some_non_default_collation`
- Closed
-
MDEV-28117 Multiple conflicting table COLLATE clauses are not rejected
- Closed