16 is the size of a text pointer that is stored in the row. The pointer points to the text root structure or the actual locatyion of the text, ntext or image data. The Ntext data type can hold about 1GB of characters. The text and image data types hold about 2GB. Do you really need that much storage for the text? In SQL 7 and 2000, varchar and char data can hold 8000 characters. nchar and nvarchar hold 4000 characters. Check the following link for more maximum capacity information.
Text, NText and Image data require special handling. It is much easier to deal with varchar or char data. These can be selected and manipulated by simple SQL comamnds. There are special commands for using the text and image data types - Readtext, Writetext and Updatetext. SQL BOL contains details. If you want to get the best answer for your question read faq183-874 and faq183-3179. Terry L. Broadbent - DBA
SQL Server Page:
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.