From f1544424de2b8c9d1c3faefbbdd15543db7dfd12 Mon Sep 17 00:00:00 2001 From: Alexander Barkov Date: Fri, 2 Sep 2022 17:32:14 +0400 Subject: MDEV-29446 Change SHOW CREATE TABLE to display default collation --- mysql-test/main/binary.result | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'mysql-test/main/binary.result') diff --git a/mysql-test/main/binary.result b/mysql-test/main/binary.result index be87c25e932..76e3ba0f054 100644 --- a/mysql-test/main/binary.result +++ b/mysql-test/main/binary.result @@ -139,7 +139,7 @@ show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `a` binary(1) DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci drop table t1; create table t1 (col1 binary(4)); insert into t1 values ('a'),('a '); -- cgit v1.2.1