Two bytes character in LIKE expression is not allowed

If you use some two bytes character like Chinese characters in like expression, you will get a SQLException.

SELECT * FROM TEST.TEST WHERE name LIKE '中文%';

java.sql.SQLException: ERROR 201 (22000): Illegal data. CHAR types may only contain single byte characters (中文)