1 files changed, 6 insertions, 6 deletions
diff --git a/storage/rocksdb/mysql-test/rocksdb/r/tbl_standard_opts.result b/storage/rocksdb/mysql-test/rocksdb/r/tbl_standard_opts.result
index f0018e782fd..5a9041c5f30 100644
--- a/storage/rocksdb/mysql-test/rocksdb/r/tbl_standard_opts.result
+++ b/storage/rocksdb/mysql-test/rocksdb/r/tbl_standard_opts.result
@@ -10,7 +10,7 @@ t1	CREATE TABLE `t1` (
   `a` int(11) NOT NULL,
   `b` char(8) DEFAULT NULL,
   PRIMARY KEY (`a`)
-) ENGINE=ROCKSDB DEFAULT CHARSET=utf8mb3 COMMENT='standard table options'
+) ENGINE=ROCKSDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='standard table options'
 ALTER TABLE t1 COMMENT = 'table altered';
 SHOW CREATE TABLE t1;
 Table	Create Table
@@ -18,7 +18,7 @@ t1	CREATE TABLE `t1` (
   `a` int(11) NOT NULL,
   `b` char(8) DEFAULT NULL,
   PRIMARY KEY (`a`)
-) ENGINE=ROCKSDB DEFAULT CHARSET=utf8mb3 COMMENT='table altered'
+) ENGINE=ROCKSDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='table altered'
 ALTER TABLE t1 ENGINE=MEMORY;
 SHOW CREATE TABLE t1;
 Table	Create Table
@@ -26,7 +26,7 @@ t1	CREATE TABLE `t1` (
   `a` int(11) NOT NULL,
   `b` char(8) DEFAULT NULL,
   PRIMARY KEY (`a`)
-) ENGINE=MEMORY DEFAULT CHARSET=utf8mb3 COMMENT='table altered'
+) ENGINE=MEMORY DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='table altered'
 ALTER TABLE t1 ENGINE=rocksdb;
 SHOW CREATE TABLE t1;
 Table	Create Table
@@ -34,13 +34,13 @@ t1	CREATE TABLE `t1` (
   `a` int(11) NOT NULL,
   `b` char(8) DEFAULT NULL,
   PRIMARY KEY (`a`)
-) ENGINE=ROCKSDB DEFAULT CHARSET=utf8mb3 COMMENT='table altered'
+) ENGINE=ROCKSDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='table altered'
 ALTER TABLE t1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci;
 SHOW CREATE TABLE t1;
 Table	Create Table
 t1	CREATE TABLE `t1` (
   `a` int(11) NOT NULL,
-  `b` char(8) CHARACTER SET utf8mb3 DEFAULT NULL,
+  `b` char(8) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
   PRIMARY KEY (`a`)
-) ENGINE=ROCKSDB DEFAULT CHARSET=latin1 COMMENT='table altered'
+) ENGINE=ROCKSDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='table altered'
 DROP TABLE t1;