MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

SELECT CHAR_LENGTH(_ucs2"Hello") AS character_length;

character_length

3

SELECT _ucs2"Hello";

䡥汬

H敬汯

SELECT _ucs2"Hel";

䡥

H敬

SELECT _ucs2"Hell";

䡥汬

䡥汬

SELECT _ucs2"Hellos";

䡥汬潳

䡥汬潳