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
1784
December 11, 2018 09:33AM
794
December 13, 2018 10:23AM
827
December 14, 2018 11:43AM
866
December 14, 2018 12:12PM
Re: Expecting utf8mb4 charset on new table
909
December 13, 2018 07:58PM
805
December 14, 2018 11:45AM
797
December 16, 2018 11:46PM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
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.