熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Java編程 >> Java核心技術 >> 正文

為什麼TEXT字段不能存取大於4K的數據

2013-11-23 19:26:46  來源: Java核心技術 

  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
From:http://tw.wingwit.com/Article/program/Java/hx/201311/26877.html
    推薦文章
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.