summaryrefslogtreecommitdiff
path: root/mysql-test/main/varbinary.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/varbinary.result')
-rw-r--r--mysql-test/main/varbinary.result8
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/main/varbinary.result b/mysql-test/main/varbinary.result
index 3a182e74692..ad8172bcfcd 100644
--- a/mysql-test/main/varbinary.result
+++ b/mysql-test/main/varbinary.result
@@ -84,7 +84,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`a` varbinary(255)/*old*/ DEFAULT NULL,
`b` varchar(255)/*old*/ DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
select length(a), length(b) from t1;
length(a) length(b)
255 3
@@ -100,7 +100,7 @@ Table Create Table
t1 CREATE TABLE `t1` (
`a` varbinary(255) DEFAULT NULL,
`b` varchar(255) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
select length(a), length(b) from t1;
length(a) length(b)
3 3
@@ -139,13 +139,13 @@ show create table table_28127_a;
Table Create Table
table_28127_a CREATE TABLE `table_28127_a` (
`0b02` int(11) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
create table table_28127_b(0b2 int);
show create table table_28127_b;
Table Create Table
table_28127_b CREATE TABLE `table_28127_b` (
`0b2` int(11) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
drop table table_28127_a;
drop table table_28127_b;
select 0b01000001;