Hi...!<br><br> Does any one know how to change text field limit in<br>SQL Server 6.5? I tried to change TEXTSIZE using SET TEXTSIZE 16384 but it did not work. I am only able to get 4096 characters. <br><br>According to Transaction-SQL HELP "The DB-Library variable DBTEXTLIMIT also limits the size of text data returned with a SELECT statement. If DBTEXTLIMIT is set to a smaller size than TEXTSIZE, only the amount specified by DBTEXTLIMIT is returned.". So my question is "How I can change DBTEXTLIMIT?".<br><br>I'll appreciate your help.<br><br>Thanks,<br><br>- DesaiD<br>
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
TEXT field size in SELECT statement
- Thread starter desaid
- Start date
Similar threads
- Locked
- Question