summaryrefslogtreecommitdiff
path: root/mysql-test/r/func_system.result
diff options
context:
space:
mode:
authorunknown <bar@bar.mysql.r18.ru>2003-08-11 18:18:34 +0500
committerunknown <bar@bar.mysql.r18.ru>2003-08-11 18:18:34 +0500
commit0960c3eb26861238d9102845d370f3eb66d91290 (patch)
tree3818f3663ab056711a4b873e3abb17725b1cb138 /mysql-test/r/func_system.result
parentf3f6e5e9b2ecfef9bf6c5e7558af2481e30385ad (diff)
downloadmariadb-git-0960c3eb26861238d9102845d370f3eb66d91290.tar.gz
Fix: create table t1 (a char(10) character set cp1251) SELECT _koi8r'blabla' as a
The above query created a field of koi8r charset, not cp1251 Change: CREATE TABLE a (a CHAR(1) CHARACTER SET utf8) Length now means character length, not byte length. The above creates a field that guarantees can store a multibyte value 1 character long. For utf8 the above creates a field that can store 3 bytes.
Diffstat (limited to 'mysql-test/r/func_system.result')
-rw-r--r--mysql-test/r/func_system.result6
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/r/func_system.result b/mysql-test/r/func_system.result
index cde21ead33c..a52d5613c04 100644
--- a/mysql-test/r/func_system.result
+++ b/mysql-test/r/func_system.result
@@ -41,9 +41,9 @@ create table t1 (version char(40)) select database(), user(), version() as 'vers
show create table t1;
Table Create Table
t1 CREATE TABLE `t1` (
- `database()` char(102) character set utf8 NOT NULL default '',
- `user()` char(231) character set utf8 NOT NULL default '',
- `version` char(40) character set utf8 default NULL
+ `database()` char(34) character set utf8 NOT NULL default '',
+ `user()` char(77) character set utf8 NOT NULL default '',
+ `version` char(40) default NULL
) TYPE=MyISAM CHARSET=latin1
drop table t1;
select TRUE,FALSE,NULL;