Sunday, February 19, 2012

Data type for "Comments" field?

Hi,

I am using SQL Server 2005 Express. I am creating a table, which will have a comments field. Whats an appropriate data type that should be used for a "comments" field? So far, I have unlimited text and characters can be entered, but that a limitation can be placed.

Thanks

Chirs

Most likely, you will be best served with varchar(max).

Varchar(max) will hold up to 2 GB of data.

No comments:

Post a Comment