diff options
| author | unknown <bar@bar.intranet.mysql.r18.ru> | 2004-03-30 21:33:45 +0500 |
|---|---|---|
| committer | unknown <bar@bar.intranet.mysql.r18.ru> | 2004-03-30 21:33:45 +0500 |
| commit | acd4d158cc0706ec9502a7063079802c48c673b0 (patch) | |
| tree | 26ded7fd609fea6994f5c380fe5b25aa341c5fcf /mysql-test/r/alter_table.result | |
| parent | b26165d3a2eeb748b9bd5573f9bac7b73d5f9a37 (diff) | |
| download | mariadb-git-acd4d158cc0706ec9502a7063079802c48c673b0.tar.gz | |
More different syntaxes for (1) modifying the default charaset/collation
and for (2) converting the columns:
1. ALTER TABLE t1 [DEFAULT] CHARACTER SET xxx [COLLATE yyy]
2. ALTER TABLE t1 CONVERT TO CHARACTER SET xxx [COLLATE yyy]
Diffstat (limited to 'mysql-test/r/alter_table.result')
| -rw-r--r-- | mysql-test/r/alter_table.result | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/mysql-test/r/alter_table.result b/mysql-test/r/alter_table.result index 9b90742762e..5166e3bf8cb 100644 --- a/mysql-test/r/alter_table.result +++ b/mysql-test/r/alter_table.result @@ -360,7 +360,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `a` char(10) character set koi8r default NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 -alter table t1 CHARACTER SET latin1; +alter table t1 CONVERT TO CHARACTER SET latin1, DEFAULT CHARACTER SET latin1; show create table t1; Table Create Table t1 CREATE TABLE `t1` ( @@ -379,15 +379,15 @@ show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `myblob` longblob, - `mytext` longtext character set latin1 collate latin1_general_cs -) ENGINE=MyISAM DEFAULT CHARSET=latin1 + `mytext` longtext collate latin1_general_cs +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs alter table t1 character set latin2; show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `myblob` longblob, - `mytext` longtext character set latin2 -) ENGINE=MyISAM DEFAULT CHARSET=latin1 + `mytext` longtext character set latin1 collate latin1_general_cs +) ENGINE=MyISAM DEFAULT CHARSET=latin2 drop table t1; CREATE TABLE t1 ( Host varchar(16) binary NOT NULL default '', |