summaryrefslogtreecommitdiff
path: root/mysql-test/suite/engines/funcs/r/ta_add_string_middle.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/engines/funcs/r/ta_add_string_middle.result')
-rw-r--r--mysql-test/suite/engines/funcs/r/ta_add_string_middle.result128
1 files changed, 64 insertions, 64 deletions
diff --git a/mysql-test/suite/engines/funcs/r/ta_add_string_middle.result b/mysql-test/suite/engines/funcs/r/ta_add_string_middle.result
index 83290046168..71d65226d4a 100644
--- a/mysql-test/suite/engines/funcs/r/ta_add_string_middle.result
+++ b/mysql-test/suite/engines/funcs/r/ta_add_string_middle.result
@@ -10,7 +10,7 @@ t5 CREATE TABLE `t5` (
`c2` char(10) DEFAULT NULL,
`c3` char(20) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t5 ADD c4 CHAR(20) NULL AFTER c2;
SHOW TABLES;
Tables_in_test
@@ -23,7 +23,7 @@ t5 CREATE TABLE `t5` (
`c4` char(20) DEFAULT NULL,
`c3` char(20) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -38,7 +38,7 @@ t5 CREATE TABLE `t5` (
`c2` varchar(10) DEFAULT NULL,
`c3` varchar(20) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t5 ADD c4 CHAR(20) NULL AFTER c2;
SHOW TABLES;
Tables_in_test
@@ -51,7 +51,7 @@ t5 CREATE TABLE `t5` (
`c4` char(20) DEFAULT NULL,
`c3` varchar(20) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -66,7 +66,7 @@ t5 CREATE TABLE `t5` (
`c2` binary(10) DEFAULT NULL,
`c3` binary(20) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t5 ADD c4 CHAR(20) NULL AFTER c2;
SHOW TABLES;
Tables_in_test
@@ -79,7 +79,7 @@ t5 CREATE TABLE `t5` (
`c4` char(20) DEFAULT NULL,
`c3` binary(20) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -94,7 +94,7 @@ t5 CREATE TABLE `t5` (
`c2` varbinary(10) DEFAULT NULL,
`c3` varbinary(20) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t5 ADD c4 CHAR(20) NULL AFTER c2;
SHOW TABLES;
Tables_in_test
@@ -107,7 +107,7 @@ t5 CREATE TABLE `t5` (
`c4` char(20) DEFAULT NULL,
`c3` varbinary(20) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -122,7 +122,7 @@ t5 CREATE TABLE `t5` (
`c2` char(10) NOT NULL,
`c3` char(20) NOT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t5 ADD c4 CHAR(20) NOT NULL AFTER c2;
SHOW TABLES;
Tables_in_test
@@ -135,7 +135,7 @@ t5 CREATE TABLE `t5` (
`c4` char(20) NOT NULL,
`c3` char(20) NOT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -150,7 +150,7 @@ t5 CREATE TABLE `t5` (
`c2` varchar(10) NOT NULL,
`c3` varchar(20) NOT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t5 ADD c4 CHAR(20) NOT NULL AFTER c2;
SHOW TABLES;
Tables_in_test
@@ -163,7 +163,7 @@ t5 CREATE TABLE `t5` (
`c4` char(20) NOT NULL,
`c3` varchar(20) NOT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -178,7 +178,7 @@ t5 CREATE TABLE `t5` (
`c2` binary(10) NOT NULL,
`c3` binary(20) NOT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t5 ADD c4 CHAR(20) NOT NULL AFTER c2;
SHOW TABLES;
Tables_in_test
@@ -191,7 +191,7 @@ t5 CREATE TABLE `t5` (
`c4` char(20) NOT NULL,
`c3` binary(20) NOT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -206,7 +206,7 @@ t5 CREATE TABLE `t5` (
`c2` varbinary(10) NOT NULL,
`c3` varbinary(20) NOT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t5 ADD c4 CHAR(20) NOT NULL AFTER c2;
SHOW TABLES;
Tables_in_test
@@ -219,7 +219,7 @@ t5 CREATE TABLE `t5` (
`c4` char(20) NOT NULL,
`c3` varbinary(20) NOT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -234,7 +234,7 @@ t5 CREATE TABLE `t5` (
`c2` char(10) DEFAULT NULL,
`c3` char(20) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t5 ADD c4 VARCHAR(20) NULL AFTER c2;
SHOW TABLES;
Tables_in_test
@@ -247,7 +247,7 @@ t5 CREATE TABLE `t5` (
`c4` varchar(20) DEFAULT NULL,
`c3` char(20) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -262,7 +262,7 @@ t5 CREATE TABLE `t5` (
`c2` varchar(10) DEFAULT NULL,
`c3` varchar(20) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t5 ADD c4 VARCHAR(20) NULL AFTER c2;
SHOW TABLES;
Tables_in_test
@@ -275,7 +275,7 @@ t5 CREATE TABLE `t5` (
`c4` varchar(20) DEFAULT NULL,
`c3` varchar(20) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -290,7 +290,7 @@ t5 CREATE TABLE `t5` (
`c2` binary(10) DEFAULT NULL,
`c3` binary(20) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t5 ADD c4 VARCHAR(20) NULL AFTER c2;
SHOW TABLES;
Tables_in_test
@@ -303,7 +303,7 @@ t5 CREATE TABLE `t5` (
`c4` varchar(20) DEFAULT NULL,
`c3` binary(20) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -318,7 +318,7 @@ t5 CREATE TABLE `t5` (
`c2` varbinary(10) DEFAULT NULL,
`c3` varbinary(20) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t5 ADD c4 VARCHAR(20) NULL AFTER c2;
SHOW TABLES;
Tables_in_test
@@ -331,7 +331,7 @@ t5 CREATE TABLE `t5` (
`c4` varchar(20) DEFAULT NULL,
`c3` varbinary(20) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -346,7 +346,7 @@ t5 CREATE TABLE `t5` (
`c2` char(10) NOT NULL,
`c3` char(20) NOT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t5 ADD c4 VARCHAR(20) NOT NULL AFTER c2;
SHOW TABLES;
Tables_in_test
@@ -359,7 +359,7 @@ t5 CREATE TABLE `t5` (
`c4` varchar(20) NOT NULL,
`c3` char(20) NOT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -374,7 +374,7 @@ t5 CREATE TABLE `t5` (
`c2` varchar(10) NOT NULL,
`c3` varchar(20) NOT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t5 ADD c4 VARCHAR(20) NOT NULL AFTER c2;
SHOW TABLES;
Tables_in_test
@@ -387,7 +387,7 @@ t5 CREATE TABLE `t5` (
`c4` varchar(20) NOT NULL,
`c3` varchar(20) NOT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -402,7 +402,7 @@ t5 CREATE TABLE `t5` (
`c2` binary(10) NOT NULL,
`c3` binary(20) NOT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t5 ADD c4 VARCHAR(20) NOT NULL AFTER c2;
SHOW TABLES;
Tables_in_test
@@ -415,7 +415,7 @@ t5 CREATE TABLE `t5` (
`c4` varchar(20) NOT NULL,
`c3` binary(20) NOT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -430,7 +430,7 @@ t5 CREATE TABLE `t5` (
`c2` varbinary(10) NOT NULL,
`c3` varbinary(20) NOT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t5 ADD c4 VARCHAR(20) NOT NULL AFTER c2;
SHOW TABLES;
Tables_in_test
@@ -443,7 +443,7 @@ t5 CREATE TABLE `t5` (
`c4` varchar(20) NOT NULL,
`c3` varbinary(20) NOT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -458,7 +458,7 @@ t5 CREATE TABLE `t5` (
`c2` char(10) DEFAULT NULL,
`c3` char(20) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t5 ADD c4 BINARY(20) NULL AFTER c2;
SHOW TABLES;
Tables_in_test
@@ -471,7 +471,7 @@ t5 CREATE TABLE `t5` (
`c4` binary(20) DEFAULT NULL,
`c3` char(20) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -486,7 +486,7 @@ t5 CREATE TABLE `t5` (
`c2` varchar(10) DEFAULT NULL,
`c3` varchar(20) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t5 ADD c4 BINARY(20) NULL AFTER c2;
SHOW TABLES;
Tables_in_test
@@ -499,7 +499,7 @@ t5 CREATE TABLE `t5` (
`c4` binary(20) DEFAULT NULL,
`c3` varchar(20) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -514,7 +514,7 @@ t5 CREATE TABLE `t5` (
`c2` binary(10) DEFAULT NULL,
`c3` binary(20) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t5 ADD c4 BINARY(20) NULL AFTER c2;
SHOW TABLES;
Tables_in_test
@@ -527,7 +527,7 @@ t5 CREATE TABLE `t5` (
`c4` binary(20) DEFAULT NULL,
`c3` binary(20) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -542,7 +542,7 @@ t5 CREATE TABLE `t5` (
`c2` varbinary(10) DEFAULT NULL,
`c3` varbinary(20) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t5 ADD c4 BINARY(20) NULL AFTER c2;
SHOW TABLES;
Tables_in_test
@@ -555,7 +555,7 @@ t5 CREATE TABLE `t5` (
`c4` binary(20) DEFAULT NULL,
`c3` varbinary(20) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -570,7 +570,7 @@ t5 CREATE TABLE `t5` (
`c2` char(10) NOT NULL,
`c3` char(20) NOT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t5 ADD c4 BINARY(20) NOT NULL AFTER c2;
SHOW TABLES;
Tables_in_test
@@ -583,7 +583,7 @@ t5 CREATE TABLE `t5` (
`c4` binary(20) NOT NULL,
`c3` char(20) NOT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -598,7 +598,7 @@ t5 CREATE TABLE `t5` (
`c2` varchar(10) NOT NULL,
`c3` varchar(20) NOT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t5 ADD c4 BINARY(20) NOT NULL AFTER c2;
SHOW TABLES;
Tables_in_test
@@ -611,7 +611,7 @@ t5 CREATE TABLE `t5` (
`c4` binary(20) NOT NULL,
`c3` varchar(20) NOT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -626,7 +626,7 @@ t5 CREATE TABLE `t5` (
`c2` binary(10) NOT NULL,
`c3` binary(20) NOT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t5 ADD c4 BINARY(20) NOT NULL AFTER c2;
SHOW TABLES;
Tables_in_test
@@ -639,7 +639,7 @@ t5 CREATE TABLE `t5` (
`c4` binary(20) NOT NULL,
`c3` binary(20) NOT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -654,7 +654,7 @@ t5 CREATE TABLE `t5` (
`c2` varbinary(10) NOT NULL,
`c3` varbinary(20) NOT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t5 ADD c4 BINARY(20) NOT NULL AFTER c2;
SHOW TABLES;
Tables_in_test
@@ -667,7 +667,7 @@ t5 CREATE TABLE `t5` (
`c4` binary(20) NOT NULL,
`c3` varbinary(20) NOT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -682,7 +682,7 @@ t5 CREATE TABLE `t5` (
`c2` char(10) DEFAULT NULL,
`c3` char(20) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t5 ADD c4 VARBINARY(20) NULL AFTER c2;
SHOW TABLES;
Tables_in_test
@@ -695,7 +695,7 @@ t5 CREATE TABLE `t5` (
`c4` varbinary(20) DEFAULT NULL,
`c3` char(20) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -710,7 +710,7 @@ t5 CREATE TABLE `t5` (
`c2` varchar(10) DEFAULT NULL,
`c3` varchar(20) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t5 ADD c4 VARBINARY(20) NULL AFTER c2;
SHOW TABLES;
Tables_in_test
@@ -723,7 +723,7 @@ t5 CREATE TABLE `t5` (
`c4` varbinary(20) DEFAULT NULL,
`c3` varchar(20) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -738,7 +738,7 @@ t5 CREATE TABLE `t5` (
`c2` binary(10) DEFAULT NULL,
`c3` binary(20) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t5 ADD c4 VARBINARY(20) NULL AFTER c2;
SHOW TABLES;
Tables_in_test
@@ -751,7 +751,7 @@ t5 CREATE TABLE `t5` (
`c4` varbinary(20) DEFAULT NULL,
`c3` binary(20) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -766,7 +766,7 @@ t5 CREATE TABLE `t5` (
`c2` varbinary(10) DEFAULT NULL,
`c3` varbinary(20) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t5 ADD c4 VARBINARY(20) NULL AFTER c2;
SHOW TABLES;
Tables_in_test
@@ -779,7 +779,7 @@ t5 CREATE TABLE `t5` (
`c4` varbinary(20) DEFAULT NULL,
`c3` varbinary(20) DEFAULT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -794,7 +794,7 @@ t5 CREATE TABLE `t5` (
`c2` char(10) NOT NULL,
`c3` char(20) NOT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t5 ADD c4 VARBINARY(20) NOT NULL AFTER c2;
SHOW TABLES;
Tables_in_test
@@ -807,7 +807,7 @@ t5 CREATE TABLE `t5` (
`c4` varbinary(20) NOT NULL,
`c3` char(20) NOT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -822,7 +822,7 @@ t5 CREATE TABLE `t5` (
`c2` varchar(10) NOT NULL,
`c3` varchar(20) NOT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t5 ADD c4 VARBINARY(20) NOT NULL AFTER c2;
SHOW TABLES;
Tables_in_test
@@ -835,7 +835,7 @@ t5 CREATE TABLE `t5` (
`c4` varbinary(20) NOT NULL,
`c3` varchar(20) NOT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -850,7 +850,7 @@ t5 CREATE TABLE `t5` (
`c2` binary(10) NOT NULL,
`c3` binary(20) NOT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t5 ADD c4 VARBINARY(20) NOT NULL AFTER c2;
SHOW TABLES;
Tables_in_test
@@ -863,7 +863,7 @@ t5 CREATE TABLE `t5` (
`c4` varbinary(20) NOT NULL,
`c3` binary(20) NOT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
@@ -878,7 +878,7 @@ t5 CREATE TABLE `t5` (
`c2` varbinary(10) NOT NULL,
`c3` varbinary(20) NOT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
ALTER TABLE t5 ADD c4 VARBINARY(20) NOT NULL AFTER c2;
SHOW TABLES;
Tables_in_test
@@ -891,7 +891,7 @@ t5 CREATE TABLE `t5` (
`c4` varbinary(20) NOT NULL,
`c3` varbinary(20) NOT NULL,
PRIMARY KEY (`c1`)
-) ENGINE=ENGINE DEFAULT CHARSET=latin1
+) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t5;
SHOW TABLES;
Tables_in_test
View Lorry Controller Status