Field type choice
Posted: Tue Aug 07, 2007 2:36 pm
I was wondering what is a better choice for field types in a MySQL database.
I use VARCHAR for most fields. However, some fields may be up to 10000 to 20000 characters and for those fields I use LONGTEXT. Is TEXT sufficient for fields up to 10000 to 15000 characters or should I stick with LONGTEXT?
I use VARCHAR for most fields. However, some fields may be up to 10000 to 20000 characters and for those fields I use LONGTEXT. Is TEXT sufficient for fields up to 10000 to 15000 characters or should I stick with LONGTEXT?