Debian Codegraph @

mysql-test/suite/vcol/t/charsets.test

raw
1 #
2 # vcol definition, table charset, current connection charset
3 #
4 set names utf8;
5 create table t1 (
6 a int,
7 b varchar(100) as (if(a,collation('й'),hex('ю')))
8 ) character set koi8r;
9 insert t1 (a) values (0),(1);
10 select * from t1;
11 set names latin1;
12 select * from t1;
13 flush tables;
14 select * from t1;
15 set names koi8r;
16 select * from t1;
17 flush tables;
18 select * from t1;
19 drop table t1;