--disable_warnings drop table if exists t1; drop view if exists v1; --enable_warnings set character_set_database = ujis; set names ujis; #create table using multi-byte column name create table t1(`£Ã£±` char(1)); insert into t1 values ('a'),('b'),('c'); #mysql hangs after this query create view v1 as select char_length(`£Ã£±`) from t1; #it happens when using other functions like # create view v1 as select length(`£Ã£±`) from t1; # create view v1 as select hex(`£Ã£±`) from t1; drop table t1; drop view v1;