is there any limit to how long of a string SqlDataReader.GetString() can return?

  • Thread starter Thread starter Daniel
  • Start date Start date
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.
 
Daniel said:
is there any limit to how long of a string SqlDataReader.GetString()
can return?

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