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
1928
December 11, 2018 09:33AM
871
December 13, 2018 10:23AM
881
December 14, 2018 11:43AM
932
December 14, 2018 12:12PM
Re: Expecting utf8mb4 charset on new table
967
December 13, 2018 07:58PM
867
December 14, 2018 11:45AM
875
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.