diff options
| author | unknown <serg@serg.mylan> | 2003-12-13 18:49:10 +0100 |
|---|---|---|
| committer | unknown <serg@serg.mylan> | 2003-12-13 18:49:10 +0100 |
| commit | bc1b68f0d866cc31fcbd321f88c216c44198bf79 (patch) | |
| tree | f72587e0ec71205d385c6165f0dfbd662cdb0d5c /mysql-test/r/ctype_recoding.result | |
| parent | f953acea9290638926cfc3ff2185848bcb80b4ff (diff) | |
| download | mariadb-git-bc1b68f0d866cc31fcbd321f88c216c44198bf79.tar.gz | |
insert table select * from table2 now converts charsets correctly
Diffstat (limited to 'mysql-test/r/ctype_recoding.result')
| -rw-r--r-- | mysql-test/r/ctype_recoding.result | 24 |
1 files changed, 22 insertions, 2 deletions
diff --git a/mysql-test/r/ctype_recoding.result b/mysql-test/r/ctype_recoding.result index 646dcb76f96..571c89ef467 100644 --- a/mysql-test/r/ctype_recoding.result +++ b/mysql-test/r/ctype_recoding.result @@ -1,7 +1,8 @@ SET CHARACTER SET koi8r; -DROP TABLE IF EXISTS таблица, t1; +DROP TABLE IF EXISTS таблица, t1, t2; SET CHARACTER SET koi8r; CREATE TABLE t1 (a CHAR(10) CHARACTER SET cp1251) SELECT _koi8r'проба' AS a; +CREATE TABLE t2 (a CHAR(10) CHARACTER SET utf8); SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( @@ -13,7 +14,26 @@ a SELECT HEX(a) FROM t1; HEX(a) EFF0EEE1E0 -DROP TABLE t1; +INSERT t2 SELECT * FROM t1; +SELECT HEX(a) FROM t2; +HEX(a) +D0BFD180D0BED0B1D0B0 +DROP TABLE t1, t2; +CREATE TABLE t1 (a TEXT CHARACTER SET cp1251) SELECT _koi8r'проба' AS a; +CREATE TABLE t2 (a TEXT CHARACTER SET utf8); +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` text character set cp1251 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 +SELECT HEX(a) FROM t1; +HEX(a) +EFF0EEE1E0 +INSERT t2 SELECT * FROM t1; +SELECT HEX(a) FROM t2; +HEX(a) +D0BFD180D0BED0B1D0B0 +DROP TABLE t1, t2; CREATE TABLE `таблица` ( поле CHAR(32) CHARACTER SET koi8r NOT NULL COMMENT "комментарий поля" |