how long is tooooo long for TEXT datatype in SQL 2000?

liunx

Guest
hai every one

while trying to insert a real long string into DB it gives me error that them max length of TEXT data type is 128 ............
How can i insert the long string........?
thanks in advance

AustinThe size of a text field is 128 bits, HOWEVER, that is used as a pointer to where the data actually is stored. Apparently, you're attempting to write directly to that field, which isn't what you want to be doing. You need to use WRITETEXT. Check out the info found here: <!-- m --><a class="postlink" href="http://search.microsoft.com/search/results.aspx?qu=WRITETEXT&View=msdn&st=b&c=4&s=1&swc=4You">http://search.microsoft.com/search/resu ... 1&swc=4You</a><!-- m --> may find UPDATETEXT helpful as well: <!-- m --><a class="postlink" href="http://search.microsoft.com/search/results.aspx?view=msdn&st=b&na=82&qu=UPDATETEXT&s=1&swc=4">http://search.microsoft.com/search/resu ... &s=1&swc=4</a><!-- m -->
 
Back
Top