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 -->
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 -->