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; |