summaryrefslogtreecommitdiff
path: root/mysql-test/suite/engines/funcs/r/tc_structure_create_select_string.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/engines/funcs/r/tc_structure_create_select_string.result')
-rw-r--r--mysql-test/suite/engines/funcs/r/tc_structure_create_select_string.result16
1 files changed, 8 insertions, 8 deletions
diff --git a/mysql-test/suite/engines/funcs/r/tc_structure_create_select_string.result b/mysql-test/suite/engines/funcs/r/tc_structure_create_select_string.result
index 99de1ed3cab..b1b9c8cb9d7 100644
--- a/mysql-test/suite/engines/funcs/r/tc_structure_create_select_string.result
+++ b/mysql-test/suite/engines/funcs/r/tc_structure_create_select_string.result
@@ -11,7 +11,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` char(10) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -27,7 +27,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` char(10) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -45,7 +45,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` varchar(10) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -61,7 +61,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` varchar(10) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -79,7 +79,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` binary(10) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -95,7 +95,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` binary(10) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -113,7 +113,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` varbinary(10) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test
@@ -129,7 +129,7 @@ dst CREATE TABLE `dst` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` varbinary(10) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE dst;
SHOW TABLES;
Tables_in_test