D Daniel Apr 19, 2006 #1 is there any limit to how long of a string SqlDataReader.GetString() can return?
K Kevin Spencer Apr 19, 2006 #2 Was there something wrong with Carls answer to your first post of this same question? -- HTH, Kevin Spencer Microsoft MVP Professional Numbskull Hard work is a medication for which there is no placebo.
Was there something wrong with Carls answer to your first post of this same question? -- HTH, Kevin Spencer Microsoft MVP Professional Numbskull Hard work is a medication for which there is no placebo.
C Carl Daniel [VC++ MVP] Apr 19, 2006 #3 Daniel said: is there any limit to how long of a string SqlDataReader.GetString() can return? Click to expand... No limit is imposed by SqlDataReader. IIRC, there is an underlying limit of 2GB imposed by SQL Server - AFIAK you should be able to pull back an entire 2Gb image as a "string", assuming you have enough memory. -cd
Daniel said: is there any limit to how long of a string SqlDataReader.GetString() can return? Click to expand... No limit is imposed by SqlDataReader. IIRC, there is an underlying limit of 2GB imposed by SQL Server - AFIAK you should be able to pull back an entire 2Gb image as a "string", assuming you have enough memory. -cd
