What are the maximum number of Characters per varchar(max) column in SQL Server?
Posted on : 16-04-2012 | By : Devi Prasad | In : SQL Server Basics
0
What are the maximum number of Characters per varchar(max) column in SQL Server?
SQL Server Supports 2^30-1 Characters per varchar(max) Column.
| Max Capacity For | SQL Server 2012 | SQL Server 2008 R2 | SQL Server 2008 | SQL Server 2005 |
|---|---|---|---|---|
| Maximum number of Characters per varchar(max) column in SQL Server | 2^30-1 Bytes | 2^30-1 Bytes | 2^30-1 Bytes | 2^30-1 Bytes |
http://msdn.microsoft.com/en-us/library/ms143432.aspx
Reference : Devi Prasad (sqlserverlearner.com)
Do you like my blog?
If you liked reading this blog, please help spread the word by sharing this blog with your friends.
Need Help On SQL Server?
Cannot Find Solution to your problem (or) If you are looking for some help on SQL Server. Dont worry Click Here to Post your question and solve your issue.
Tags: character size limit for varchar column, character size limit for varchar max column, character size limit for varchar(max) column, Characters in nvarchar column in SQL Server, Characters per nvarchar column in SQL Server, max Characters in nvarchar column in SQL Server, max Characters per nvarchar column in SQL Server, maximum number of Characters per varchar(max) column in SQL Server, maximum number of Characters per varchar(max) datatype in SQL Server, varchar max size limit, varchar max size limit sql server, varchar max size limit sql server 2005, varchar max size limit sql server 2008, varchar max size limit sql server 2008 r2, varchar max size limit sql server 2012, What are the maximum number of Characters per varchar(max) column in SQL Server 2005, What are the maximum number of Characters per varchar(max) column in SQL Server 2008, What are the maximum number of Characters per varchar(max) column in SQL Server 2008 r2, What are the maximum number of Characters per varchar(max) column in SQL Server 2012
