Un limited data Store in field

[imshally81]

hi all, I have a field which name is Information and it type is Varchar (8000),but some time data access than 8000 character, my client told me,make this field to store Unlimited data. So how can i achive this task, i m using VS 2003 (ASP.NET with VB.NET) with SQL 2000. Thanks Shally

[Andy Brummer]

Look up ntext, text and image in SQL books online. These types will let you store data blobs limited only by the storage space on the server. They do have limits on the types of queries you can run on them so make sure they fit your needs.

---

I can imagine the sinking feeling one would have after ordering my book, only to find a laughably ridiculous theory with demented logic once the book arrives - Mark McCutcheon

[airbus380]

Why ? What is the goal ?

[Colin Angus Mackay]

text and ntext are not unlimited. There is an upper limit of 2Gb.

---

My: Blog | Photos WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

[Andy Brummer]

Thanks.

---

I can imagine the sinking feeling one would have after ordering my book, only to find a laughably ridiculous theory with demented logic once the book arrives - Mark McCutcheon