diff options
Diffstat (limited to 'mysql-test/main/partition_utf8.result')
-rw-r--r-- | mysql-test/main/partition_utf8.result | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/mysql-test/main/partition_utf8.result b/mysql-test/main/partition_utf8.result index 956ee790160..e3a27d0438f 100644 --- a/mysql-test/main/partition_utf8.result +++ b/mysql-test/main/partition_utf8.result @@ -5,8 +5,8 @@ partition by list columns (a) show create table t1; Table Create Table t1 CREATE TABLE `t1` ( - `a` varchar(2) CHARACTER SET cp1250 DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 + `a` varchar(2) CHARACTER SET cp1250 COLLATE cp1250_general_ci DEFAULT NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY LIST COLUMNS(`a`) (PARTITION `p0` VALUES IN (_cp1250 0x81) ENGINE = MyISAM) drop table t1; @@ -16,8 +16,8 @@ partition by list columns (a) show create table t1; Table Create Table t1 CREATE TABLE `t1` ( - `a` varchar(2) CHARACTER SET cp1250 DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 + `a` varchar(2) CHARACTER SET cp1250 COLLATE cp1250_general_ci DEFAULT NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY LIST COLUMNS(`a`) (PARTITION `p0` VALUES IN ('€') ENGINE = MyISAM) drop table t1; @@ -43,8 +43,8 @@ partition p1 values in ('')); show create table t1; Table Create Table t1 CREATE TABLE `t1` ( - `a` varchar(2) CHARACTER SET ucs2 DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 + `a` varchar(2) CHARACTER SET ucs2 COLLATE ucs2_general_ci DEFAULT NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY LIST COLUMNS(`a`) (PARTITION `p0` VALUES IN ('†') ENGINE = MyISAM, PARTITION `p1` VALUES IN ('') ENGINE = MyISAM) |