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
