How to store word documents in sql server using ASP.Net 2.0??

[kvPriya]

Hai, I’ve to store the contents in word/text documents along with the format in SQL Server table field. The document may be upto 3MB. But, the length of varbinary and varchar fields in SQL Server can be of 8000 at the max. Any suggestions….Please welcome. -Priya

[Anshuman Singh]

take db field ntext

Anshuman Singh [anshumas@rediffmail.com](mailto:Anshuman Singhanshumas@rediffmail.com)

[kvPriya]

It's able to store only upto 250 characters. But, my file size may be upto 3MB.How can I store the content of such a file??

[Guffa]

kvPriya wrote:

It's able to store only upto 250 characters.

Not at all. It's able to store up to 2147483648 characters. To store a binary file though, you should rather use the image data type. It's capable of storing up to 4 GiB.

--- b { font-weight: normal; }