Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What data type is best for storing comments in SQL Server?

What is an effective datatype in SQL 2005 to store a comments field?

like image 231
Csharp Avatar asked Mar 01 '23 10:03

Csharp


1 Answers

If the comment will always fit in 8000 chars then varchar(8000) (or nvarchar(4000)).

Otherwise a varchar(max)

like image 56
Mitch Wheat Avatar answered Mar 03 '23 05:03

Mitch Wheat