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?
Subject
Views
Written By
Posted
1758
December 11, 2018 09:33AM
781
December 13, 2018 10:23AM
809
December 14, 2018 11:43AM
843
December 14, 2018 12:12PM
Re: Expecting utf8mb4 charset on new table
896
December 13, 2018 07:58PM
781
December 14, 2018 11:45AM
787
December 16, 2018 11:46PM
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.