Search code examples
sqlcommentssql-types

SQL large comment field


I have been asked to code an SQL table that has a comment field that:

must be able to store at least several pages of text

What data type should I use, and what value equates to several pages of text?


Solution

  • In MS SQL varchar(max) stores a maximum of 2 147 483 647 characters