According to the user guide, it is mentioned that TEXT data type is
recommended over CHAR or VARCHAR. Does anyone know why? I thought the
access time for TEXT is slower. Shouldn't CHAR be used for key fields?
Is there some sort of overheads for CHAR or VARCHAR that TEXT is
recommended? Hope that someone has an answer to this recommendation.
Thanks,
Thomas Lim.