utf8 char accounting failure on inserts

[Andrew Hutchings]

drizzle> create table t1 (a int, b varchar(255));
Query OK, 0 rows affected (0.16 sec)

drizzle> insert into t1 values (1, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin at metus in mauris consectetur hendrerit. Donec nec nulla mauris, ut adipiscing augue. Donec eu lorem at felis malesuada tristique quis sit amet arcu. Morbi hendrerit cursus lectus et posuere. ');
ERROR 1406 (22001): Data too long for column 'b' at row 1

drizzle> insert into t1 values (1, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin at metus in mauris consectetur hendrerit. Donec nec nulla mauris, ut adipiscing augue. Donec eu lorem at felis malesuada tristique quis sit amet arcu. Morbi hendrerit cursus lectus et posuere.');
Query OK, 1 row affected (0.08 sec)

Note that it is blocking inserts longer that 255 bytes rather than 255 characters (the first insert has an extra space at the end making it 256 characters).

[Andrew Hutchings (linuxjedi)]

grr... really silly of me, !bug

[Andrew Hutchings (linuxjedi)]

data source I used said it was giving my 256bytes utf8. Like a fool I believed it without trying to count it.