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

microsoft.public.dotnet.framework

19 Apr 2006 3:41 AM

Daniel

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

19 Apr 2006 11:06 AM

Kevin Spencer

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.

Show quote

"Daniel" <softwareengineer98***@yahoo.com> wrote in message
news:%234ArnM2YGHA.3936@TK2MSFTNGP05.phx.gbl...
> is there any limit to how long of a string SqlDataReader.GetString() can
> return?
>
>

19 Apr 2006 1:36 PM

Carl Daniel [VC++ MVP]

Daniel wrote:

> 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