diff options
author | Sergei Golubchik <serg@mariadb.org> | 2021-09-05 13:09:40 +0200 |
---|---|---|
committer | Sergei Golubchik <serg@mariadb.org> | 2021-10-12 13:28:10 +0200 |
commit | 8150f52e4769cd3b894549656933987c1ef8af2d (patch) | |
tree | b5bc02460ab8966d65e351a058eecf367c4fac9c /mysql-test/main/func_sformat.result | |
parent | fe65ca0176e126f0b33bfcfdaab1154c0bfabe42 (diff) | |
download | mariadb-git-8150f52e4769cd3b894549656933987c1ef8af2d.tar.gz |
support charsets with mbminlen > 1
Diffstat (limited to 'mysql-test/main/func_sformat.result')
-rw-r--r-- | mysql-test/main/func_sformat.result | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/main/func_sformat.result b/mysql-test/main/func_sformat.result index 2a221373521..f2631c32d65 100644 --- a/mysql-test/main/func_sformat.result +++ b/mysql-test/main/func_sformat.result @@ -417,3 +417,23 @@ sformat('{:p}', '50') NULL Warnings: Warning 4183 SFORMAT error: invalid type specifier +# +# ucs2 test +# +select sformat('={}=', _ucs2 x'006100620063'); +sformat('={}=', _ucs2 x'006100620063') +=abc= +set names utf8; +select sformat(_ucs2 x'003D007B007D003D', _ucs2 x'0442043504410442'); +sformat(_ucs2 x'003D007B007D003D', _ucs2 x'0442043504410442') +=ัะตัั= +select hex(sformat(_ucs2 x'003D007B007D003D', _ucs2 x'0442043504410442')); +hex(sformat(_ucs2 x'003D007B007D003D', _ucs2 x'0442043504410442')) +003D0442043504410442003D +create table t1 as select sformat(_ucs2 x'003D007B007D003D', _ucs2 x'0442043504410442') as x; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `x` varchar(8) CHARACTER SET ucs2 DEFAULT NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1 +drop table t1; |