| Author: Manick 03 Nov 2009 | Member Level: Gold | Rating:  Points: 2 |
In SQL server 2005..
Varchar(max) – It will allow us to use sequence of characters greater than 8000 bytes (8000 characters). The maximum size is 2GB.
nVarchar(max) - It will allow us to use sequence of characters greater than 8000 bytes (4000 characters). The maximum size is 2GB.
VarBinary(max) - It will allow us to use binary data greater than 8000 bytes.
Regards, Manick
|
| Author: Tamil Maran 03 Nov 2009 | Member Level: Gold | Rating:  Points: 2 |
Refer This
http://www.teratrax.com/sql_guide/data_types/sql_server_data_types.html
Thz Jagadish.J
|