Database Problem

Hello,

I am using SQL server. But SQL server has some limit to save data means maximumlength is 8000 for varchar per raw.Waht should I do if I want to save unlimited data. Should I use XML

Thanks

Ronak Bhagdev

That 8000 character limit for a varchar is not present in SQL Server 2005 (you can use varchar(MAX) to have up to some very large number of characters available).

In SQL Server 2000, you can use the text or ntext type, which has an insanely high limit to size. Sadly, there are some limitations that mean you cannot use the text field in a WHERE clause (unless you are using full text indexing, I believe).

|||

Hello,

First Thank you very much!

You mean sql server 2005 has also some limit to store data. If I want unlimited data then...

One more question SQL server express edition supporttext field ?

Thanks