Q Why cant I access more than K of data in a TEXT field in SQL Server?
为什么TEXT字段不能存取大于K的数据?
A Probably because you havent set the TEXTSIZE parameter SET TEXTSIZE <n>
Specifies the size in bytes of text data to be returned with a SELECT statement If you specify a TEXTSIZE of the size is reset to the default (K) Setting TEXTSIZE affects the global variable @@TEXTSIZE
The DBLibrary 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 For more information see Microsoft SQL Server Programming DBLibrary for C
也许你没有设置TEXTSIZE参数
SET TEXTSIZE <n>
用字节数指定SELECT语句返回的文本大小如果指定大小为则设为默认值(K)设置TEXTSIZE参数影响全局变量@@TEXTSIZE
DBLibrary变量DBTEXTLIMIT也限制SELECT语句返回的文本大小如果DBTEXTLIMIT比TEXTSIZE小则按DBTEXTLIMIT的设置返回数据更多的内容请看Microsoft SQL Server Programming DBLibrary for C