Hello everyone,
For storing character data such as surname, email address which
is the best data type to use?
This is my guess:
Char - For small columns, fixed length in record
VarChar - Is this fixed length in record? If not then is it stored in an
'overflow' area
which will effect performance. Maybe theres an allocated length that sets how
much is stored in the record
Text - Only differences seems to be that no length is specified
Can each of these be indexed???
Which of these is fastest considering hard disks are so cheap I don't much care
about which takes the most bytes!
NB The HTML manual didn't seem to explain this in detail - can anyone help me?
Cheers,
MC
