Debian Codegraph @

mysql-test/suite/vcol/r/charsets.result

raw
1 set names utf8;
2 create table t1 (
3 a int,
4 b varchar(100) as (if(a,collation('й'),hex('ю')))
5 ) character set koi8r;
6 insert t1 (a) values (0),(1);
7 select * from t1;
8 a b
9 0 C0
10 1 koi8r_general_ci
11 set names latin1;
12 select * from t1;
13 a b
14 0 C0
15 1 koi8r_general_ci
16 flush tables;
17 select * from t1;
18 a b
19 0 C0
20 1 koi8r_general_ci
21 set names koi8r;
22 select * from t1;
23 a b
24 0 C0
25 1 koi8r_general_ci
26 flush tables;
27 select * from t1;
28 a b
29 0 C0
30 1 koi8r_general_ci
31 drop table t1;