Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Differnce Between varchar(8000) & varchar(80)

Author  Topic 

aoriju
Posting Yak Master

156 Posts

Posted - 2008-11-03 : 04:25:23
Dear All,
.This Question is a general.i am using a field with varchar(8000).Everyone know 8000 is maximum length of varchar.The concept of varchar is it using needed space.rest of the space not using and not taking the memory.

My question is for security we can put varchar(8000).
whats happening when we varchar(8000) & varchar(80).

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-11-03 : 05:04:39
varchar(8000) can hold a maximum of 8000 characters while varchar(80) can hold only a maximum of 80 characters.
Go to Top of Page

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2008-11-03 : 05:20:09
this might help you

http://en.wikipedia.org/wiki/Varchar

and
http://msdn.microsoft.com/en-us/library/ms176089.aspx
Go to Top of Page
   

- Advertisement -