|
1
by brian
clean slate |
1 |
--source include/have_ucs2.inc
|
2 |
||
3 |
--disable_warnings
|
|
4 |
drop table if exists `£Ô£±`; |
|
5 |
drop table if exists `£Ô£²`; |
|
6 |
drop table if exists `£Ô£³`; |
|
7 |
drop table if exists `£Ô£Ž`; |
|
8 |
drop table if exists `£Ô£µ`; |
|
9 |
drop table if exists `£Ô£¶`; |
|
10 |
drop table if exists `£Ô£·`; |
|
11 |
drop table if exists `£Ô£ž`; |
|
12 |
drop table if exists `£Ô£¹`; |
|
13 |
drop table if exists `£Ô£±£°`; |
|
14 |
drop table if exists `£Ô£±£±`; |
|
15 |
drop table if exists `£Ô£±£²`; |
|
16 |
--enable_warnings
|
|
17 |
||
18 |
#
|
|
19 |
# Test Displaying Japanese charact in ucs2 encoding |
|
20 |
#
|
|
21 |
||
22 |
SET NAMES ujis; |
|
23 |
SET character_set_database = ucs2; |
|
24 |
SET collation_connection = ucs2_general_ci; |
|
25 |
||
26 |
CREATE TABLE `£Ô£±` (c1 char(20), INDEX(c1)) DEFAULT CHARSET = ucs2 engine = innodb; |
|
27 |
CREATE TABLE `£Ô£²` (c1 char(20), INDEX(c1)) DEFAULT CHARSET = ucs2 engine = innodb; |
|
28 |
CREATE TABLE `£Ô£³` (c1 char(20), INDEX(c1)) DEFAULT CHARSET = ucs2 engine = innodb; |
|
29 |
CREATE TABLE `£Ô£Ž` (c1 char(20), INDEX(c1)) DEFAULT CHARSET = ucs2 engine = myisam; |
|
30 |
CREATE TABLE `£Ô£µ` (c1 char(20), INDEX(c1)) DEFAULT CHARSET = ucs2 engine = myisam; |
|
31 |
CREATE TABLE `£Ô£¶` (c1 char(20), INDEX(c1)) DEFAULT CHARSET = ucs2 engine = myisam; |
|
32 |
CREATE TABLE `£Ô£·` (c1 char(20), INDEX(c1)) DEFAULT CHARSET = ucs2 engine = heap; |
|
33 |
CREATE TABLE `£Ô£ž` (c1 char(20), INDEX(c1)) DEFAULT CHARSET = ucs2 engine = heap; |
|
34 |
CREATE TABLE `£Ô£¹` (c1 char(20), INDEX(c1)) DEFAULT CHARSET = ucs2 engine = heap; |
|
35 |
CREATE TABLE `£Ô£±£°` (c1 char(20), INDEX(c1)) DEFAULT CHARSET = ucs2 engine = bdb; |
|
36 |
CREATE TABLE `£Ô£±£±` (c1 char(20), INDEX(c1)) DEFAULT CHARSET = ucs2 engine = bdb; |
|
37 |
CREATE TABLE `£Ô£±£²` (c1 char(20), INDEX(c1)) DEFAULT CHARSET = ucs2 engine = bdb; |
|
38 |
||
39 |
#INSERT the following data in each table |
|
40 |
# jisx0201 hankaku-katakana data |
|
41 |
# jisx0208 data |
|
42 |
# jisx0212 supplemental character data |
|
43 |
||
44 |
INSERT INTO `£Ô£±` VALUES |
|
45 |
('PQRSTUVWXYZ[\\]^_') |
|
46 |
,(' ¡¢£€¥Š§š©ª«¬®¯') |
|
47 |
,('°±²³Žµ¶·ž¹º»ŒœŸ¿') |
|
48 |
,('ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏ') |
|
49 |
,('ÐÑÒÓÔÕÖ×ØÙÚÛÜÝÞß'); |
|
50 |
||
51 |
INSERT INTO `£Ô£²` VALUES |
|
52 |
('¡Ž¡µ¡¶¡·¡ž¡¹¡º¡»¡Œ¡œ¡Ÿ¡¿¡À¡Á¡Â¡Ã¡Ä¡Å¡Æ¡Ç') |
|
53 |
,('¡È¡É¡Ê¡Ë¡Ì¡Í¡Î¡Ï¡Ð¡Ñ¡Ò¡Ó¡Ô¡Õ¡Ö¡×¡Ø¡Ù¡Ú¡Û') |
|
54 |
,('¡Š€¡€¢€£€€€¥€Š€§€š€©€ª€«€¬€€®€¯€°€±€²€³') |
|
55 |
,('¡Š¥¡¥¢¥£¥€¥¥¥Š¥§¥š¥©¥ª¥«¥¬¥¥®¥¯¥°¥±¥²¥³') |
|
56 |
,('¡Š°¡°¢°£°€°¥°Š°§°š°©°ª°«°¬°°®°¯°°°±°²°³') |
|
57 |
,('¡ŠÐ¡Ð¢Ð£Ð€Ð¥ÐŠÐ§ÐšÐ©ÐªÐ«Ð¬ÐЮЯабвг') |
|
58 |
,('¡Šó¡ó¢ó£ó€ó¥óŠó§óšó©óªó«ó¬óó®ó¯ó°ó±ó²ó³'); |
|
59 |
||
60 |
INSERT INTO `£Ô£³` VALUES |
|
61 |
('¡Š¢µ¢¶¢·¢ž¢¹¡Š¡Š¡Š¡Š¡Š¡Š¡Š¡Š¢Â¢Ã¢Ä¡Š¡Š¡Š') |
|
62 |
,('°Ž°µ°¶°·°ž°¹°º°»°Œ°œ°Ÿ°¿°À°Á°Â°Ã°Ä°Å°Æ°Ç') |
|
63 |
,('°È°É°Ê°Ë°Ì°Í°Î°Ï°Ð°Ñ°Ò°Ó°Ô°Õ°Ö°×°Ø°Ù°Ú°Û') |
|
64 |
,('°Ü°Ý°Þ°ß°à°á°â°ã°ä°å°æ°ç°è°é°ê°ë°ì°í°î°ï') |
|
65 |
,('¡Ší¡í¢í£í€í¥íŠí§íší©íªí«í¬íí®í¯í°í±í²í³') |
|
66 |
,('íŽíµí¶í·íží¹íºí»íŒíœíŸí¿íÀíÁíÂíÃíÄíÅíÆíÇ') |
|
67 |
,('íÈíÉíÊíËíÌíÍíÎíÏíÐíÑíÒíÓíÔíÕíÖí×íØíÙíÚíÛ'); |
|
68 |
||
69 |
INSERT INTO `£Ô£Ž` VALUES |
|
70 |
('PQRSTUVWXYZ[\\]^_') |
|
71 |
,(' ¡¢£€¥Š§š©ª«¬®¯') |
|
72 |
,('°±²³Žµ¶·ž¹º»ŒœŸ¿') |
|
73 |
,('ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏ') |
|
74 |
,('ÐÑÒÓÔÕÖ×ØÙÚÛÜÝÞß'); |
|
75 |
||
76 |
INSERT INTO `£Ô£µ` VALUES |
|
77 |
('¡Ž¡µ¡¶¡·¡ž¡¹¡º¡»¡Œ¡œ¡Ÿ¡¿¡À¡Á¡Â¡Ã¡Ä¡Å¡Æ¡Ç') |
|
78 |
,('¡È¡É¡Ê¡Ë¡Ì¡Í¡Î¡Ï¡Ð¡Ñ¡Ò¡Ó¡Ô¡Õ¡Ö¡×¡Ø¡Ù¡Ú¡Û') |
|
79 |
,('¡Š€¡€¢€£€€€¥€Š€§€š€©€ª€«€¬€€®€¯€°€±€²€³') |
|
80 |
,('¡Š¥¡¥¢¥£¥€¥¥¥Š¥§¥š¥©¥ª¥«¥¬¥¥®¥¯¥°¥±¥²¥³') |
|
81 |
,('¡Š°¡°¢°£°€°¥°Š°§°š°©°ª°«°¬°°®°¯°°°±°²°³') |
|
82 |
,('¡ŠÐ¡Ð¢Ð£Ð€Ð¥ÐŠÐ§ÐšÐ©ÐªÐ«Ð¬ÐЮЯабвг') |
|
83 |
,('¡Šó¡ó¢ó£ó€ó¥óŠó§óšó©óªó«ó¬óó®ó¯ó°ó±ó²ó³'); |
|
84 |
||
85 |
INSERT INTO `£Ô£¶` VALUES |
|
86 |
('¡Š¢µ¢¶¢·¢ž¢¹¡Š¡Š¡Š¡Š¡Š¡Š¡Š¡Š¢Â¢Ã¢Ä¡Š¡Š¡Š') |
|
87 |
,('°Ž°µ°¶°·°ž°¹°º°»°Œ°œ°Ÿ°¿°À°Á°Â°Ã°Ä°Å°Æ°Ç') |
|
88 |
,('°È°É°Ê°Ë°Ì°Í°Î°Ï°Ð°Ñ°Ò°Ó°Ô°Õ°Ö°×°Ø°Ù°Ú°Û') |
|
89 |
,('°Ü°Ý°Þ°ß°à°á°â°ã°ä°å°æ°ç°è°é°ê°ë°ì°í°î°ï') |
|
90 |
,('¡Ší¡í¢í£í€í¥íŠí§íší©íªí«í¬íí®í¯í°í±í²í³') |
|
91 |
,('íŽíµí¶í·íží¹íºí»íŒíœíŸí¿íÀíÁíÂíÃíÄíÅíÆíÇ') |
|
92 |
,('íÈíÉíÊíËíÌíÍíÎíÏíÐíÑíÒíÓíÔíÕíÖí×íØíÙíÚíÛ'); |
|
93 |
||
94 |
INSERT INTO `£Ô£·` VALUES |
|
95 |
('PQRSTUVWXYZ[\\]^_') |
|
96 |
,(' ¡¢£€¥Š§š©ª«¬®¯') |
|
97 |
,('°±²³Žµ¶·ž¹º»ŒœŸ¿') |
|
98 |
,('ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏ') |
|
99 |
,('ÐÑÒÓÔÕÖ×ØÙÚÛÜÝÞß'); |
|
100 |
||
101 |
INSERT INTO `£Ô£ž` VALUES |
|
102 |
('¡Ž¡µ¡¶¡·¡ž¡¹¡º¡»¡Œ¡œ¡Ÿ¡¿¡À¡Á¡Â¡Ã¡Ä¡Å¡Æ¡Ç') |
|
103 |
,('¡È¡É¡Ê¡Ë¡Ì¡Í¡Î¡Ï¡Ð¡Ñ¡Ò¡Ó¡Ô¡Õ¡Ö¡×¡Ø¡Ù¡Ú¡Û') |
|
104 |
,('¡Š€¡€¢€£€€€¥€Š€§€š€©€ª€«€¬€€®€¯€°€±€²€³') |
|
105 |
,('¡Š¥¡¥¢¥£¥€¥¥¥Š¥§¥š¥©¥ª¥«¥¬¥¥®¥¯¥°¥±¥²¥³') |
|
106 |
,('¡Š°¡°¢°£°€°¥°Š°§°š°©°ª°«°¬°°®°¯°°°±°²°³') |
|
107 |
,('¡ŠÐ¡Ð¢Ð£Ð€Ð¥ÐŠÐ§ÐšÐ©ÐªÐ«Ð¬ÐЮЯабвг') |
|
108 |
,('¡Šó¡ó¢ó£ó€ó¥óŠó§óšó©óªó«ó¬óó®ó¯ó°ó±ó²ó³'); |
|
109 |
||
110 |
INSERT INTO `£Ô£¹` VALUES |
|
111 |
('¡Š¢µ¢¶¢·¢ž¢¹¡Š¡Š¡Š¡Š¡Š¡Š¡Š¡Š¢Â¢Ã¢Ä¡Š¡Š¡Š') |
|
112 |
,('°Ž°µ°¶°·°ž°¹°º°»°Œ°œ°Ÿ°¿°À°Á°Â°Ã°Ä°Å°Æ°Ç') |
|
113 |
,('°È°É°Ê°Ë°Ì°Í°Î°Ï°Ð°Ñ°Ò°Ó°Ô°Õ°Ö°×°Ø°Ù°Ú°Û') |
|
114 |
,('°Ü°Ý°Þ°ß°à°á°â°ã°ä°å°æ°ç°è°é°ê°ë°ì°í°î°ï') |
|
115 |
,('¡Ší¡í¢í£í€í¥íŠí§íší©íªí«í¬íí®í¯í°í±í²í³') |
|
116 |
,('íŽíµí¶í·íží¹íºí»íŒíœíŸí¿íÀíÁíÂíÃíÄíÅíÆíÇ') |
|
117 |
,('íÈíÉíÊíËíÌíÍíÎíÏíÐíÑíÒíÓíÔíÕíÖí×íØíÙíÚíÛ'); |
|
118 |
||
119 |
INSERT INTO `£Ô£±£°` VALUES |
|
120 |
('PQRSTUVWXYZ[\\]^_') |
|
121 |
,(' ¡¢£€¥Š§š©ª«¬®¯') |
|
122 |
,('°±²³Žµ¶·ž¹º»ŒœŸ¿') |
|
123 |
,('ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏ') |
|
124 |
,('ÐÑÒÓÔÕÖ×ØÙÚÛÜÝÞß'); |
|
125 |
||
126 |
INSERT INTO `£Ô£±£±` VALUES |
|
127 |
('¡Ž¡µ¡¶¡·¡ž¡¹¡º¡»¡Œ¡œ¡Ÿ¡¿¡À¡Á¡Â¡Ã¡Ä¡Å¡Æ¡Ç') |
|
128 |
,('¡È¡É¡Ê¡Ë¡Ì¡Í¡Î¡Ï¡Ð¡Ñ¡Ò¡Ó¡Ô¡Õ¡Ö¡×¡Ø¡Ù¡Ú¡Û') |
|
129 |
,('¡Š€¡€¢€£€€€¥€Š€§€š€©€ª€«€¬€€®€¯€°€±€²€³') |
|
130 |
,('¡Š¥¡¥¢¥£¥€¥¥¥Š¥§¥š¥©¥ª¥«¥¬¥¥®¥¯¥°¥±¥²¥³') |
|
131 |
,('¡Š°¡°¢°£°€°¥°Š°§°š°©°ª°«°¬°°®°¯°°°±°²°³') |
|
132 |
,('¡ŠÐ¡Ð¢Ð£Ð€Ð¥ÐŠÐ§ÐšÐ©ÐªÐ«Ð¬ÐЮЯабвг') |
|
133 |
,('¡Šó¡ó¢ó£ó€ó¥óŠó§óšó©óªó«ó¬óó®ó¯ó°ó±ó²ó³'); |
|
134 |
||
135 |
INSERT INTO `£Ô£±£²` VALUES |
|
136 |
('¡Š¢µ¢¶¢·¢ž¢¹¡Š¡Š¡Š¡Š¡Š¡Š¡Š¡Š¢Â¢Ã¢Ä¡Š¡Š¡Š') |
|
137 |
,('°Ž°µ°¶°·°ž°¹°º°»°Œ°œ°Ÿ°¿°À°Á°Â°Ã°Ä°Å°Æ°Ç') |
|
138 |
,('°È°É°Ê°Ë°Ì°Í°Î°Ï°Ð°Ñ°Ò°Ó°Ô°Õ°Ö°×°Ø°Ù°Ú°Û') |
|
139 |
,('°Ü°Ý°Þ°ß°à°á°â°ã°ä°å°æ°ç°è°é°ê°ë°ì°í°î°ï') |
|
140 |
,('¡Ší¡í¢í£í€í¥íŠí§íší©íªí«í¬íí®í¯í°í±í²í³') |
|
141 |
,('íŽíµí¶í·íží¹íºí»íŒíœíŸí¿íÀíÁíÂíÃíÄíÅíÆíÇ') |
|
142 |
,('íÈíÉíÊíËíÌíÍíÎíÏíÐíÑíÒíÓíÔíÕíÖí×íØíÙíÚíÛ'); |
|
143 |
||
144 |
#InnoDB |
|
145 |
SELECT * FROM `£Ô£±`; |
|
146 |
SELECT * FROM `£Ô£²`; |
|
147 |
SELECT * FROM `£Ô£³`; |
|
148 |
#MyISAM |
|
149 |
SELECT * FROM `£Ô£Ž`; |
|
150 |
SELECT * FROM `£Ô£µ`; |
|
151 |
SELECT * FROM `£Ô£¶`; |
|
152 |
#Heap |
|
153 |
SELECT * FROM `£Ô£·`; |
|
154 |
SELECT * FROM `£Ô£ž`; |
|
155 |
SELECT * FROM `£Ô£¹`; |
|
156 |
#BDB |
|
157 |
SELECT * FROM `£Ô£±£°`; |
|
158 |
SELECT * FROM `£Ô£±£±`; |
|
159 |
SELECT * FROM `£Ô£±£²`; |
|
160 |
||
161 |
drop table `£Ô£±`; |
|
162 |
drop table `£Ô£²`; |
|
163 |
drop table `£Ô£³`; |
|
164 |
drop table `£Ô£Ž`; |
|
165 |
drop table `£Ô£µ`; |
|
166 |
drop table `£Ô£¶`; |
|
167 |
drop table `£Ô£·`; |
|
168 |
drop table `£Ô£ž`; |
|
169 |
drop table `£Ô£¹`; |
|
170 |
drop table `£Ô£±£°`; |
|
171 |
drop table `£Ô£±£±`; |
|
172 |
drop table `£Ô£±£²`; |