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
 Database Design and Application Architecture
 largest text field size allowed?

Author  Topic 

adrianle
Starting Member

3 Posts

Posted - 2010-08-31 : 15:04:35
I have a customer wanting me to build a "journal" for her.. which is easy enough, but I'm curious what the maximum number of characters can be entered into a single text column in a SQL server 2005 table? What column type should I use? Thanks-

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-08-31 : 15:19:48
varchar(max). 2^31-1 bytes (2,147,483,647 characters)
Go to Top of Page
   

- Advertisement -