diff options
| author | unknown <bar@bar.intranet.mysql.r18.ru> | 2004-03-19 11:37:49 +0400 |
|---|---|---|
| committer | unknown <bar@bar.intranet.mysql.r18.ru> | 2004-03-19 11:37:49 +0400 |
| commit | 8bbb6d2b42f8f7f6ce50171addc4d57c5d2c81f4 (patch) | |
| tree | cd74cc53bbea916c56fa4ee6b5672e3c0780cc14 /mysql-test/r/alter_table.result | |
| parent | bf4e1d4681554a9c8369ebce6c33fecac197f0e7 (diff) | |
| download | mariadb-git-8bbb6d2b42f8f7f6ce50171addc4d57c5d2c81f4.tar.gz | |
Bug #2821 Table default character set affects LONGBLOB fields
Diffstat (limited to 'mysql-test/r/alter_table.result')
| -rw-r--r-- | mysql-test/r/alter_table.result | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/r/alter_table.result b/mysql-test/r/alter_table.result index 703cc59d9a4..dee7433404f 100644 --- a/mysql-test/r/alter_table.result +++ b/mysql-test/r/alter_table.result @@ -343,6 +343,22 @@ t1 CREATE TABLE `t1` ( `a` char(10) character set latin1 default NULL ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 drop table t1; +create table t1 (myblob longblob,mytext longtext) +default charset latin1 collate latin1_general_cs; +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 +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 +drop table t1; CREATE TABLE t1 ( Host varchar(16) binary NOT NULL default '', User varchar(16) binary NOT NULL default '', |