Jump to content

InnoDB

From tango.info wiki

http://dev.mysql.com/doc/refman/5.5/en/innodb-restrictions.html "On Windows, InnoDB always stores database and table names internally in lowercase."

http://dev.mysql.com/doc/refman/5.6/en/innodb-storage-engine.html InnoDB support for FULLTEXT indexes is available in MySQL 5.6.4 and higher.

Conversion

ALTER TABLE `t` ENGINE = INNODB
ALTER TABLE `t` ROW_FORMAT = DYNAMIC
ALTER TABLE `t` ENGINE = INNODB ROW_FORMAT = DYNAMIC