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