source include/have_innodb.inc; set names 'utf8'; show variables like 'char%'; CREATE TABLE testit ( a char(32), PRIMARY KEY ( a ) ) ENGINE=INNODB; INSERT INTO testit (a) VALUE ('value1'); SELECT * FROM testit WHERE a = 'value1'; DELETE FROM testit WHERE a = 'value1'; SELECT * FROM testit;