create database unicode_data_db; | |
use unicode_data_db; | |
-- test simple unicode data | |
create table t_test (name string, value int) ; | |
insert into table t_test VALUES ('李四', 100),('ちぱっち', 200); | |
select name, value from t_test; | |
select name, value from t_test where name='李四'; | |
-- test view with unicode predicate | |
create view t_view_test as select value from t_test where name='李四'; | |
explain select * from t_view_test; | |
select * from t_view_test; | |
drop database unicode_data_db cascade; |