summaryrefslogtreecommitdiff
path: root/mysql-test/suite/jp/r/jp_alter_ujis.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/jp/r/jp_alter_ujis.result')
-rw-r--r--mysql-test/suite/jp/r/jp_alter_ujis.result36
1 files changed, 18 insertions, 18 deletions
diff --git a/mysql-test/suite/jp/r/jp_alter_ujis.result b/mysql-test/suite/jp/r/jp_alter_ujis.result
index a46da01e1cd..a59c1e5a051 100644
--- a/mysql-test/suite/jp/r/jp_alter_ujis.result
+++ b/mysql-test/suite/jp/r/jp_alter_ujis.result
@@ -44,7 +44,7 @@ Table Create Table
PRIMARY KEY (`キキキ`),
UNIQUE KEY `ククク` (`ククク`),
KEY `カカカ` (`カカ`)
-) ENGINE=InnoDB DEFAULT CHARSET=ujis
+) ENGINE=InnoDB DEFAULT CHARSET=ujis COLLATE=ujis_japanese_ci
ALTER TABLE `アアア` DROP INDEX `カカカ`;
ALTER TABLE `アアア` DROP PRIMARY KEY;
ALTER TABLE `アアア` DROP INDEX `ククク`;
@@ -63,7 +63,7 @@ SHOW CREATE TABLE `アアア`;
Table Create Table
アアア CREATE TABLE `アアア` (
`キキキ` char(6) NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=ujis
+) ENGINE=InnoDB DEFAULT CHARSET=ujis COLLATE=ujis_japanese_ci
ALTER TABLE `あああ` ADD `かかか` char(1) FIRST;
ALTER TABLE `あああ` ADD `くくく` char(1) AFTER `ききき`;
ALTER TABLE `あああ` ADD `けけけ` char(1);
@@ -93,7 +93,7 @@ Table Create Table
PRIMARY KEY (`ききき`),
UNIQUE KEY `くくく` (`くくく`),
KEY `かかか` (`かか`)
-) ENGINE=InnoDB DEFAULT CHARSET=ujis
+) ENGINE=InnoDB DEFAULT CHARSET=ujis COLLATE=ujis_japanese_ci
ALTER TABLE `あああ` DROP INDEX `かかか`;
ALTER TABLE `あああ` DROP PRIMARY KEY;
ALTER TABLE `あああ` DROP INDEX `くくく`;
@@ -112,7 +112,7 @@ SHOW CREATE TABLE `あああ`;
Table Create Table
あああ CREATE TABLE `あああ` (
`ききき` char(6) NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=ujis
+) ENGINE=InnoDB DEFAULT CHARSET=ujis COLLATE=ujis_japanese_ci
ALTER TABLE `龖龖龖` ADD `丄丄丄` char(1) FIRST;
ALTER TABLE `龖龖龖` ADD `丅丅丅` char(1) AFTER `丂丂丂`;
ALTER TABLE `龖龖龖` ADD `乚乚乚` char(1);
@@ -142,7 +142,7 @@ Table Create Table
PRIMARY KEY (`丂丂丂`),
UNIQUE KEY `丅丅丅` (`丅丅丅`),
KEY `丄丄丄` (`丄丄`)
-) ENGINE=InnoDB DEFAULT CHARSET=ujis
+) ENGINE=InnoDB DEFAULT CHARSET=ujis COLLATE=ujis_japanese_ci
ALTER TABLE `龖龖龖` DROP INDEX `丄丄丄`;
ALTER TABLE `龖龖龖` DROP PRIMARY KEY;
ALTER TABLE `龖龖龖` DROP INDEX `丅丅丅`;
@@ -161,7 +161,7 @@ SHOW CREATE TABLE `龖龖龖`;
Table Create Table
龖龖龖 CREATE TABLE `龖龖龖` (
`丂丂丂` char(6) NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=ujis
+) ENGINE=InnoDB DEFAULT CHARSET=ujis COLLATE=ujis_japanese_ci
DROP TABLE `アアア`;
DROP TABLE `イイイ`;
DROP TABLE `あああ`;
@@ -206,7 +206,7 @@ Table Create Table
PRIMARY KEY (`キキキ`),
UNIQUE KEY `ククク` (`ククク`),
KEY `カカカ` (`カカ`)
-) ENGINE=MyISAM DEFAULT CHARSET=ujis
+) ENGINE=MyISAM DEFAULT CHARSET=ujis COLLATE=ujis_japanese_ci
ALTER TABLE `アアア` DROP INDEX `カカカ`;
ALTER TABLE `アアア` DROP PRIMARY KEY;
ALTER TABLE `アアア` DROP INDEX `ククク`;
@@ -225,7 +225,7 @@ SHOW CREATE TABLE `アアア`;
Table Create Table
アアア CREATE TABLE `アアア` (
`キキキ` char(6) NOT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=ujis
+) ENGINE=MyISAM DEFAULT CHARSET=ujis COLLATE=ujis_japanese_ci
ALTER TABLE `あああ` ADD `かかか` char(1) FIRST;
ALTER TABLE `あああ` ADD `くくく` char(1) AFTER `ききき`;
ALTER TABLE `あああ` ADD `けけけ` char(1);
@@ -255,7 +255,7 @@ Table Create Table
PRIMARY KEY (`ききき`),
UNIQUE KEY `くくく` (`くくく`),
KEY `かかか` (`かか`)
-) ENGINE=MyISAM DEFAULT CHARSET=ujis
+) ENGINE=MyISAM DEFAULT CHARSET=ujis COLLATE=ujis_japanese_ci
ALTER TABLE `あああ` DROP INDEX `かかか`;
ALTER TABLE `あああ` DROP PRIMARY KEY;
ALTER TABLE `あああ` DROP INDEX `くくく`;
@@ -274,7 +274,7 @@ SHOW CREATE TABLE `あああ`;
Table Create Table
あああ CREATE TABLE `あああ` (
`ききき` char(6) NOT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=ujis
+) ENGINE=MyISAM DEFAULT CHARSET=ujis COLLATE=ujis_japanese_ci
ALTER TABLE `龖龖龖` ADD `丄丄丄` char(1) FIRST;
ALTER TABLE `龖龖龖` ADD `丅丅丅` char(1) AFTER `丂丂丂`;
ALTER TABLE `龖龖龖` ADD `乚乚乚` char(1);
@@ -304,7 +304,7 @@ Table Create Table
PRIMARY KEY (`丂丂丂`),
UNIQUE KEY `丅丅丅` (`丅丅丅`),
KEY `丄丄丄` (`丄丄`)
-) ENGINE=MyISAM DEFAULT CHARSET=ujis
+) ENGINE=MyISAM DEFAULT CHARSET=ujis COLLATE=ujis_japanese_ci
ALTER TABLE `龖龖龖` DROP INDEX `丄丄丄`;
ALTER TABLE `龖龖龖` DROP PRIMARY KEY;
ALTER TABLE `龖龖龖` DROP INDEX `丅丅丅`;
@@ -323,7 +323,7 @@ SHOW CREATE TABLE `龖龖龖`;
Table Create Table
龖龖龖 CREATE TABLE `龖龖龖` (
`丂丂丂` char(6) NOT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=ujis
+) ENGINE=MyISAM DEFAULT CHARSET=ujis COLLATE=ujis_japanese_ci
DROP TABLE `アアア`;
DROP TABLE `イイイ`;
DROP TABLE `あああ`;
@@ -368,7 +368,7 @@ Table Create Table
PRIMARY KEY (`キキキ`),
UNIQUE KEY `ククク` (`ククク`),
KEY `カカカ` (`カカ`)
-) ENGINE=MEMORY DEFAULT CHARSET=ujis
+) ENGINE=MEMORY DEFAULT CHARSET=ujis COLLATE=ujis_japanese_ci
ALTER TABLE `アアア` DROP INDEX `カカカ`;
ALTER TABLE `アアア` DROP PRIMARY KEY;
ALTER TABLE `アアア` DROP INDEX `ククク`;
@@ -387,7 +387,7 @@ SHOW CREATE TABLE `アアア`;
Table Create Table
アアア CREATE TABLE `アアア` (
`キキキ` char(6) NOT NULL
-) ENGINE=MEMORY DEFAULT CHARSET=ujis
+) ENGINE=MEMORY DEFAULT CHARSET=ujis COLLATE=ujis_japanese_ci
ALTER TABLE `あああ` ADD `かかか` char(1) FIRST;
ALTER TABLE `あああ` ADD `くくく` char(1) AFTER `ききき`;
ALTER TABLE `あああ` ADD `けけけ` char(1);
@@ -417,7 +417,7 @@ Table Create Table
PRIMARY KEY (`ききき`),
UNIQUE KEY `くくく` (`くくく`),
KEY `かかか` (`かか`)
-) ENGINE=MEMORY DEFAULT CHARSET=ujis
+) ENGINE=MEMORY DEFAULT CHARSET=ujis COLLATE=ujis_japanese_ci
ALTER TABLE `あああ` DROP INDEX `かかか`;
ALTER TABLE `あああ` DROP PRIMARY KEY;
ALTER TABLE `あああ` DROP INDEX `くくく`;
@@ -436,7 +436,7 @@ SHOW CREATE TABLE `あああ`;
Table Create Table
あああ CREATE TABLE `あああ` (
`ききき` char(6) NOT NULL
-) ENGINE=MEMORY DEFAULT CHARSET=ujis
+) ENGINE=MEMORY DEFAULT CHARSET=ujis COLLATE=ujis_japanese_ci
ALTER TABLE `龖龖龖` ADD `丄丄丄` char(1) FIRST;
ALTER TABLE `龖龖龖` ADD `丅丅丅` char(1) AFTER `丂丂丂`;
ALTER TABLE `龖龖龖` ADD `乚乚乚` char(1);
@@ -466,7 +466,7 @@ Table Create Table
PRIMARY KEY (`丂丂丂`),
UNIQUE KEY `丅丅丅` (`丅丅丅`),
KEY `丄丄丄` (`丄丄`)
-) ENGINE=MEMORY DEFAULT CHARSET=ujis
+) ENGINE=MEMORY DEFAULT CHARSET=ujis COLLATE=ujis_japanese_ci
ALTER TABLE `龖龖龖` DROP INDEX `丄丄丄`;
ALTER TABLE `龖龖龖` DROP PRIMARY KEY;
ALTER TABLE `龖龖龖` DROP INDEX `丅丅丅`;
@@ -485,7 +485,7 @@ SHOW CREATE TABLE `龖龖龖`;
Table Create Table
龖龖龖 CREATE TABLE `龖龖龖` (
`丂丂丂` char(6) NOT NULL
-) ENGINE=MEMORY DEFAULT CHARSET=ujis
+) ENGINE=MEMORY DEFAULT CHARSET=ujis COLLATE=ujis_japanese_ci
DROP TABLE `アアア`;
DROP TABLE `イイイ`;
DROP TABLE `あああ`;