What is maximum character count for SQL field

[BrimReap]

What is maximum character count for SQL field with data type text or ntext?

I'm trying to copy and paste a 63,000 character/39000 Bytes Word document and upload into the database via a form.

It keeps truncating. Do you know what the maximum amount allowed is? Do I need to change some settings?

 

[tlbroadbent]

Text max: 2GB NText max: 1GB (NText is double byte)

Check the following links for information on loading Text and NText columns.

HOWTO: Access and Modify SQL Server BLOB Data by Using the ADO Stream Object

http://support.microsoft.com/default.aspx?kbid=258038

HOWTO: Read and Write BLOBs Using GetChunk and AppendChunk

http://support.microsoft.com/default.aspx?kbid=194975

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm