summaryrefslogtreecommitdiff
path: root/mysql-test/main/type_bit_innodb.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/type_bit_innodb.result')
-rw-r--r--mysql-test/main/type_bit_innodb.result8
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/main/type_bit_innodb.result b/mysql-test/main/type_bit_innodb.result
index 9b186207f3f..9ab8fe00538 100644
--- a/mysql-test/main/type_bit_innodb.result
+++ b/mysql-test/main/type_bit_innodb.result
@@ -42,7 +42,7 @@ show create table t1;
Table Create Table
t1 CREATE TABLE `t1` (
`a` bit(1) DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=latin1
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
drop table t1;
create table t1 (a bit(64)) engine=innodb;
insert into t1 values
@@ -388,21 +388,21 @@ Table Create Table
t1 CREATE TABLE `t1` (
`a` bit(1) DEFAULT NULL,
`b` bit(10) DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=latin1
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
alter table t1 engine=heap;
show create table t1;
Table Create Table
t1 CREATE TABLE `t1` (
`a` bit(1) DEFAULT NULL,
`b` bit(10) DEFAULT NULL
-) ENGINE=MEMORY DEFAULT CHARSET=latin1
+) ENGINE=MEMORY DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
alter table t1 engine=innodb;
show create table t1;
Table Create Table
t1 CREATE TABLE `t1` (
`a` bit(1) DEFAULT NULL,
`b` bit(10) DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=latin1
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
drop table t1;
create table t1 (a bit(7)) engine=innodb;
insert into t1 values (0x60);