PDA

View Full Version : MYSQL Text Field Minimum Length Stored


adonow
08-05-2005, 11:56 PM
(1) Can you tell me what the minimum length that Host Rocket implementation of MYSQL stores for a Text type field (if the field is not used in an ADD transaction for a record containing a Text type field)? I believe the maximum is up to 65,535, if it is used. Does MySQL keep track of the actual end of the field by using a delimiter?.

(2) For a Varchar field, I believe the following is true. Is this right?
Varchar stores up to 255 characters, and a minimum of 4 characters. No trailing spaces are appended to the end of this datatype. MySQL keeps track of a delimiter to keep track of the end of the field.

Thanks for your help.

adonow
08-11-2005, 03:08 AM
For those interested, Column Type Storage Requirements are provided on the mysql.com web site, on page storage-requirements.html

dev.mysql.com/doc/mysql/en/storage-requirements.html