SQL Server, field length of 20000

itHighway · December 23rd, 2004, 05:09 PM

Hello!

This is Zeeshan Ahmed. I have posted my problem in several forums, but no one can give me satisfactory answer.

I need to store text of around 20000 characters in sql server table field. The maximum characters allowed for Varchar field is 8000.

How can I save my text of 20000 character in sql server field.

Any Idea..
Any Help....
Will be greatly appriciated..

Thank you,
Zeeshan Ahmed

om_prakash · December 24th, 2004, 01:30 AM

You can use "text" datatype which can store upto 2,147,483,647 characters.

Om Prakash

itHighway · December 24th, 2004, 04:43 PM

Thank you

Vadivel · December 27th, 2004, 01:16 AM

Yeah om prakash is right. But i guess you should be aware that text columns have limitations that varchar columns don't have!

For ex: you can't index them, and you can't use them with some cursor types.

These limitations might require you to use special funcitons such as updatetext, writetext and AADO's stream interfaces. We would use text in row only if data in some of the rows needed more space than varchar or nvarchar (here n = national)

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com