Re: Expecting utf8mb4 charset on new table

[Xing Zhang]

Which version are you using? I tried 8.0.14, and got
DROP TABLE IF EXISTS `zzzTest`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `zzzTest` (
`Count` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`Count`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

And, when you use mysql to load table_file.txt to create the table, can you 'show create table' to see whether it is created with utf8mb4?