diff options
author | bar@gw.udmsearch.izhnet.ru <> | 2002-06-07 17:23:33 +0500 |
---|---|---|
committer | bar@gw.udmsearch.izhnet.ru <> | 2002-06-07 17:23:33 +0500 |
commit | 1a91646854196e7690ef6d915ae3f7fdf6d05543 (patch) | |
tree | 373045c1e640111ad3fe37dcee286991bf677594 /mysql-test/r/select.result | |
parent | b62fafaa1507f057988c1d0fa7a2bda81ca71cec (diff) | |
download | mariadb-git-1a91646854196e7690ef6d915ae3f7fdf6d05543.tar.gz |
Charset of any string field now can be specified during CREATE TABLE
Diffstat (limited to 'mysql-test/r/select.result')
-rw-r--r-- | mysql-test/r/select.result | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/mysql-test/r/select.result b/mysql-test/r/select.result index 8c8e3b492b6..49ce0608fc5 100644 --- a/mysql-test/r/select.result +++ b/mysql-test/r/select.result @@ -3211,17 +3211,17 @@ Field Type Null Key Default Extra Privileges Comment auto int(11) PRI NULL auto_increment select,insert,update,references fld1 int(6) unsigned zerofill UNI 000000 select,insert,update,references companynr tinyint(2) unsigned zerofill 00 select,insert,update,references -fld3 char(30) MUL select,insert,update,references -fld4 char(35) select,insert,update,references -fld5 char(35) select,insert,update,references -fld6 char(4) select,insert,update,references +fld3 char(30) character set latin1 MUL select,insert,update,references +fld4 char(35) character set latin1 select,insert,update,references +fld5 char(35) character set latin1 select,insert,update,references +fld6 char(4) character set latin1 select,insert,update,references show full columns from t2 from test like 'f%'; Field Type Null Key Default Extra Privileges Comment fld1 int(6) unsigned zerofill UNI 000000 select,insert,update,references -fld3 char(30) MUL select,insert,update,references -fld4 char(35) select,insert,update,references -fld5 char(35) select,insert,update,references -fld6 char(4) select,insert,update,references +fld3 char(30) character set latin1 MUL select,insert,update,references +fld4 char(35) character set latin1 select,insert,update,references +fld5 char(35) character set latin1 select,insert,update,references +fld6 char(4) character set latin1 select,insert,update,references show full columns from t2 from test like 's%'; Field Type Null Key Default Extra Privileges Comment show keys from t2; |