best way to store a large "memo" data type in MS SQL

TechBoyJK

Lifer
Oct 17, 2002
16,699
60
91
well, I need to allow up to 5000 characters in a column, and would like for line breaks and simple formatting to be preserved.

I don't see a limit on varchar, but im thinking text is the best way to go... im not sure and im not very experienced in the pros and cons.... any advice?