summaryrefslogtreecommitdiff
path: root/mysql-test/t/ctype_many.test
diff options
context:
space:
mode:
authorunknown <bar@bar.mysql.r18.ru>2002-12-19 09:38:25 +0400
committerunknown <bar@bar.mysql.r18.ru>2002-12-19 09:38:25 +0400
commitbc7f8302a4723a078150455e4f2096167e4268eb (patch)
tree2419d4e1328ce3e2d98a650f580034b845a07f16 /mysql-test/t/ctype_many.test
parent2cae041aa8724c443208693053c488caa5499421 (diff)
downloadmariadb-git-bc7f8302a4723a078150455e4f2096167e4268eb.tar.gz
Introducing SAPDB-style
"fieldname CHAR(n) UNICODE" as a synonym to "fieldname CHAR(n) CHARACTER SET ucs2"
Diffstat (limited to 'mysql-test/t/ctype_many.test')
-rw-r--r--mysql-test/t/ctype_many.test3
1 files changed, 2 insertions, 1 deletions
diff --git a/mysql-test/t/ctype_many.test b/mysql-test/t/ctype_many.test
index 1e89b1419d2..650badfa39c 100644
--- a/mysql-test/t/ctype_many.test
+++ b/mysql-test/t/ctype_many.test
@@ -156,7 +156,8 @@ FROM t1 t11,t1 t12
WHERE t11.koi8_ru_f=CONVERT(t12.utf8_f USING koi8_ru)
ORDER BY t12.utf8_f,t11.comment,t12.comment;
-ALTER TABLE t1 ADD ucs2_f CHAR(32) CHARACTER SET ucs2 NOT NULL;
+ALTER TABLE t1 ADD ucs2_f CHAR(32) CHARACTER SET ucs2;
+ALTER TABLE t1 CHANGE ucs2_f ucs2_f CHAR(32) UNICODE NOT NULL;
INSERT INTO t1 (ucs2_f,comment) VALUES (0x0391,'GREEK CAPIT ALPHA');
INSERT INTO t1 (ucs2_f,comment) VALUES (0x0392,'GREEK CAPIT BETA');