Have the Table Types changed from MySQL 4.x to 5.0?

Support for the old ISAM tables (used until MySQL 3.22) was removed in MySQL 5.0. To convert a table from ISAM to MyISAM, simply issue a statement like ALTER TABLE tblname ENGINE=MYISAM.

The "internal RAID" support in MyISAM tables was also removed. This was an old feature used to allow large tables with file systems that did not support large (>2GB) files. All modern file systems allow for larger tables, and there are also other solutions such as MERGE tables and VIEWs.

The VARCHAR column type now retains any trailing spaces (all storage engines).

MEMORY tables (called HEAP, prior to MySQL version 4.1) can now also contain VARCHAR columns.