Table Creation
Posted: Tue Oct 07, 2003 12:24 pm
Under the URL: http://www.thunderstone.com/site/texism ... 0000000000
The paragraph:
The 100 character suggestion in this case is used for memory allocation, rather than field length limitation. Therefore a VARCHAR length should be entered as the average, rather than the largest size for that field. Entering an extremely large length to accommodate one or two unusual entries would impair the handling of memory for normal operations.
If you had indeed followed this suggestion and entered the varchar(2000) as noted and a user entered 2100 characters What would happen?
The paragraph:
The 100 character suggestion in this case is used for memory allocation, rather than field length limitation. Therefore a VARCHAR length should be entered as the average, rather than the largest size for that field. Entering an extremely large length to accommodate one or two unusual entries would impair the handling of memory for normal operations.
If you had indeed followed this suggestion and entered the varchar(2000) as noted and a user entered 2100 characters What would happen?