The 4 means that the int datatype uses four bytes of memory. > I know that int type can hold from -2,147,483,648 to 2,147,483,647, > but when we design the table, we put the length to be 4. So even if we > set the length to 4, can it hold more than 4 digits? I believe it can, > but I forgot the explanation for it. Something about 8^4, but that is > the size of smallint and not int.
varchar(20) means that the field will store up to 20 characters, which is 20 bytes. For Unicode support, e.g. nvarchar(20) in SQL Server 2000- (20) will allow up to 20 characters, but takes up to 40 bytes. > > The same thing when we design a field for username, we put varchar(20), > does that mean this field can only hold 20 characters? > Johnny ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195003 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
