create table t1 (s1 tinytext character set utf8); insert into t1 select repeat('a',100); insert into t1 select repeat('Ñ',87); #insert into t1 select repeat('aÑ',300); #insert into t1 select repeat('Ña',300); #insert into t1 select repeat('ÑÑ',300); #select hex(s1) from t1; select length(s1),char_length(s1) from t1; drop table t1; #create table t1 (s1 text character set utf8); #insert into t1 select repeat('a',66000); #insert into t1 select repeat('Ñ',66000); #insert into t1 select repeat('aÑ',66000); #insert into t1 select repeat('Ña',66000); #insert into t1 select repeat('ÑÑ',66000); #select length(s1),char_length(s1) from t1; #drop table t1;