Re: Expecting utf8mb4 charset on new table
Posted by: Xing Zhang
Date: December 13, 2018 07:58PM

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?

Options: ReplyQuote


Subject
Views
Written By
Posted
985
December 11, 2018 09:33AM
Re: Expecting utf8mb4 charset on new table
389
December 13, 2018 07:58PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.