Variable Data Types

[Dysan]

What is meant by variable Data Types?

[laserlight]

In what context did you find this term used?

[Dysan]

CHAR( ) A fixed section from 0 to 255 characters long.
VARCHAR( ) A variable section from 0 to 255 characters long.
TINYTEXT A string with a maximum length of 255 characters.
TEXT A string with a maximum length of 65535 characters.
BLOB A string with a maximum length of 65535 characters.
MEDIUMTEXT A string with a maximum length of 16777215 characters.
MEDIUMBLOB A string with a maximum length of 16777215 characters.
LONGTEXT A string with a maximum length of 4294967295 characters.
LONGBLOB A string with a maximum length of 4294967295 characters.

On this website: http://www.htmlite.com/mysql003.php

[laserlight]

That just means that the number of characters for a VARCHAR column is variable. If you provide 100 characters, it will take up space proportional to 100 characters.

[Dysan]

What's the difference between varchar and char?

[NogDog]

RTFM: http://dev.mysql.com/doc/refman/5.0/en/char.html