diff options
Diffstat (limited to 'mysql-test/main/type_nchar.test')
-rw-r--r-- | mysql-test/main/type_nchar.test | 36 |
1 files changed, 36 insertions, 0 deletions
diff --git a/mysql-test/main/type_nchar.test b/mysql-test/main/type_nchar.test new file mode 100644 index 00000000000..f2258830450 --- /dev/null +++ b/mysql-test/main/type_nchar.test @@ -0,0 +1,36 @@ +# +# Test nchar/nvarchar +# +--disable_warnings +drop table if exists t1; +--enable_warnings + +create table t1 (c nchar(10)); +show create table t1; +drop table t1; + +create table t1 (c national char(10)); +show create table t1; +drop table t1; + +create table t1 (c national varchar(10)); +show create table t1; +drop table t1; + +create table t1 (c nvarchar(10)); +show create table t1; +drop table t1; + +create table t1 (c nchar varchar(10)); +show create table t1; +drop table t1; + +create table t1 (c national character varying(10)); +show create table t1; +drop table t1; + +create table t1 (c nchar varying(10)); +show create table t1; +drop table t1; + +# End of 4.1 tests |