Char versus Text

[Dan Kelly]

We are in the process of migrating an Informix database across to MySQL 5.0.45 using an in-house developed application.

As part of the process Char fields in the Informix database are migrated across as TinyText, so as not to lose any data (we've not been able to identify the char lengths in automatically).

We are trying to decide whether it is worth our while going through the migrated tables changing these Tinytext fields back to the appropriate chars. Will we get any advantage in MySQL (other than possibly table size) from having Chars over TinyText? Will this be greater if we have no text fields in the table?

Thanks

Dan