• joncooney73 (8/13/2009)


    You would ASSUME 'range of values' implies string length here. Obviously it doesn't.

    I don't believe so. The range of numeric values is limited because the datatype is limited. Obviously, the datatype of int is not the same as the datatype of long.

    However, in the case of varchar, the length of the string that it can hold does not alter the definition of the datatype. varchar(4) is the same datatype as varchar(8000). The maximum length of the string that it holds is a property of the implementation of that datatype -- not the definition of the datatype.

    Hope that helps!