{"id":145,"date":"2012-04-16T12:30:03","date_gmt":"2012-04-16T12:30:03","guid":{"rendered":"https:\/\/sqlserverlearner.azurewebsites.net\/2012\/04\/16\/what-is-the-maximum-size-of-text-coulmn-in-sql-server\/"},"modified":"2012-04-16T12:30:03","modified_gmt":"2012-04-16T12:30:03","slug":"what-is-the-maximum-size-of-text-coulmn-in-sql-server","status":"publish","type":"post","link":"https:\/\/sqlserverlearner.com\/2012\/04\/16\/what-is-the-maximum-size-of-text-coulmn-in-sql-server\/","title":{"rendered":"What is the maximum size of text coulmn in SQL Server?"},"content":{"rendered":"<p>table.hovertable {<br \/>\nfont-family: verdana,arial,sans-serif;<br \/>\nfont-size:11px;<br \/>\ncolor:#333333;<br \/>\nborder-width: 1px;<br \/>\nborder-color: #999999;<br \/>\nborder-collapse: collapse;<br \/>\n}<br \/>\ntable.hovertable th {<br \/>\nbackground-color:#c3dde0;<br \/>\nborder-width: 1px;<br \/>\npadding: 8px;<br \/>\nborder-style: solid;<br \/>\nborder-color: #a9c6c9;<br \/>\n}<br \/>\ntable.hovertable tr {<br \/>\nbackground-color:#d4e3e5;<br \/>\n}<br \/>\ntable.hovertable td {<br \/>\nborder-width: 1px;<br \/>\npadding: 8px;<br \/>\nborder-style: solid;<br \/>\nborder-color: #a9c6c9;<br \/>\n}<\/p>\n<p>What are the maximum Bytes per text column in SQL Server?<br \/>\nSQL Server Supports 2^31-1 Bytes per text Column.<\/p>\n<table class=\"hovertable\">\n<tbody>\n<tr align=\"center\">\n<th>Max Capacity For<\/th>\n<th>SQL Server 2012<\/th>\n<th>SQL Server 2008 R2<\/th>\n<th>SQL Server 2008<\/th>\n<th>SQL Server 2005<\/th>\n<\/tr>\n<tr>\n<td>\nMaximum Bytes per text column in SQL Server\n<\/td>\n<td>\n2^31-1 Bytes\n<\/td>\n<td>\n2^31-1 Bytes\n<\/td>\n<td>\n2^31-1 Bytes\n<\/td>\n<td>\n2^31-1 Bytes\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\n<a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ms143432.aspx\">http:\/\/msdn.microsoft.com\/en-us\/library\/ms143432.aspx<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>table.hovertable { font-family: verdana,arial,sans-serif; font-size:11px; color:#333333; border-width: 1px; border-color: #999999; border-collapse: collapse; } table.hovertable th { background-color:#c3dde0; border-width: 1px; padding: 8px; border-style: solid; border-color: #a9c6c9; } table.hovertable tr { background-color:#d4e3e5; } table.hovertable td { border-width: 1px; padding: 8px; border-style: solid; border-color: #a9c6c9; } What are the maximum Bytes per text column in SQL Server? SQL&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[41],"tags":[1362,1363,1364,1365,1366,1367,1368,1369,1370,1371,1372,1373,1374,1375,1376,1377,1378,1379,1380,1381,1382,1383,1384,1385,1386,1387,1388,1389,1390,1391],"_links":{"self":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/145"}],"collection":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/comments?post=145"}],"version-history":[{"count":0,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/145\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/media?parent=145"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/categories?post=145"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/tags?post=145"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}