Originally posted by Bobba Buoy
I am confused. When I use a varchar datatype, the default field length in 255. When I set it to text, it is 16. Anything you can tell me about this would be much appreciated.
From the Holy Book (Sql server books online)
Unless the text in row option is specified, text, ntext, or image strings are large character or binary strings (up to 2 gigabytes) stored outside a data row. The data row contains only a 16-byte text pointer that points to the root node of a tree built of internal pointers that map the pages in which the string fragments are stored.
Moreover varchar datatype can store upto 8000 bytes of data