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