summaryrefslogtreecommitdiff
path: root/mysql-test/suite/engines/funcs/r/ix_index_lob.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/engines/funcs/r/ix_index_lob.result')
-rw-r--r--mysql-test/suite/engines/funcs/r/ix_index_lob.result32
1 files changed, 16 insertions, 16 deletions
diff --git a/mysql-test/suite/engines/funcs/r/ix_index_lob.result b/mysql-test/suite/engines/funcs/r/ix_index_lob.result
index cbc421d092d..00be3cc852d 100644
--- a/mysql-test/suite/engines/funcs/r/ix_index_lob.result
+++ b/mysql-test/suite/engines/funcs/r/ix_index_lob.result
@@ -9,7 +9,7 @@ Table Create Table
t4 CREATE TABLE `t4` (
`c1` tinyblob DEFAULT NULL,
KEY `i1` (`c1`(100))
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
@@ -23,7 +23,7 @@ Table Create Table
t4 CREATE TABLE `t4` (
`c1` blob DEFAULT NULL,
KEY `i1` (`c1`(100))
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
@@ -37,7 +37,7 @@ Table Create Table
t4 CREATE TABLE `t4` (
`c1` mediumblob DEFAULT NULL,
KEY `i1` (`c1`(100))
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
@@ -51,7 +51,7 @@ Table Create Table
t4 CREATE TABLE `t4` (
`c1` longblob DEFAULT NULL,
KEY `i1` (`c1`(100))
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
@@ -65,7 +65,7 @@ Table Create Table
t4 CREATE TABLE `t4` (
`c1` tinytext DEFAULT NULL,
KEY `i1` (`c1`(100))
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
@@ -79,7 +79,7 @@ Table Create Table
t4 CREATE TABLE `t4` (
`c1` text DEFAULT NULL,
KEY `i1` (`c1`(100))
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
@@ -93,7 +93,7 @@ Table Create Table
t4 CREATE TABLE `t4` (
`c1` mediumtext DEFAULT NULL,
KEY `i1` (`c1`(100))
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
@@ -107,7 +107,7 @@ Table Create Table
t4 CREATE TABLE `t4` (
`c1` longtext DEFAULT NULL,
KEY `i1` (`c1`(100))
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
@@ -121,7 +121,7 @@ Table Create Table
t4 CREATE TABLE `t4` (
`c1` tinyblob NOT NULL,
KEY `i1` (`c1`(100))
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
@@ -135,7 +135,7 @@ Table Create Table
t4 CREATE TABLE `t4` (
`c1` blob NOT NULL,
KEY `i1` (`c1`(100))
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
@@ -149,7 +149,7 @@ Table Create Table
t4 CREATE TABLE `t4` (
`c1` mediumblob NOT NULL,
KEY `i1` (`c1`(100))
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
@@ -163,7 +163,7 @@ Table Create Table
t4 CREATE TABLE `t4` (
`c1` longblob NOT NULL,
KEY `i1` (`c1`(100))
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
@@ -177,7 +177,7 @@ Table Create Table
t4 CREATE TABLE `t4` (
`c1` tinytext NOT NULL,
KEY `i1` (`c1`(100))
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
@@ -191,7 +191,7 @@ Table Create Table
t4 CREATE TABLE `t4` (
`c1` text NOT NULL,
KEY `i1` (`c1`(100))
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
@@ -205,7 +205,7 @@ Table Create Table
t4 CREATE TABLE `t4` (
`c1` mediumtext NOT NULL,
KEY `i1` (`c1`(100))
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test
@@ -219,7 +219,7 @@ Table Create Table
t4 CREATE TABLE `t4` (
`c1` longtext NOT NULL,
KEY `i1` (`c1`(100))
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t4;
SHOW TABLES;
Tables_in_test