MySQL development

Q: How long are TINYTEXT, TEXT, and MEDIUMTEXT variables?
A: googling around and then looking on MySQL Reference Manual this is the result

• TINYTEXT is 255 (2⁸ – 1) max characters
• TEXT is 65,535 (2¹⁶ – 1) max characters
• MEDIUMTEXT is 16,777,215 (2²⁴ – 1)max characters
• LONGTEXT is 4,294,967,295 or 4GB (2³² – 1) max characters

Q: What are the differences between MyISAM and InnoDB engines?
A: two articles very usefull

• Tabelle in MySQL, MyISAM vs INNODB
• MySQL - InnoDB vs MyISAM