Over 4,500 characters...but my usual data type (nvarchar) is too small at 4,000...what do I use instead?
Posted on 2005-05-04
I usually use nvarchar to store text in my databases...however, I know need to store at least 4,500......and I add another 1,200 new chars per new month (stats collection and storage).
How can I store such large amount of data? Which data type supports this, I suppose I will need 15,000... 10 months worth of growth...but still I need more... I'll probably run this for at least another year...
...so how else can I store 15,000 to 30,000 characters?