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

Agreed. I had only tested with the varchar SQL data type. Testing with TEXT
shows that it can handle much more but reaching the maximum is taking too
much time and resources. So I suppose Dan could be right about available
memory.

Nathan H. Omukwenyi

"Jeremy" <nospam@xxxxxxxx> wrote in message
news:O5fxDqBaGHA.4752@xxxxxxxxxxxxxxxxxxxxxxx
I believe the only limitation is the underlying data type in sql. For
example a varchar can only be max 8000 chars. but text could be up to 2
gigs.

"Daniel" <softwareengineer98037@xxxxxxxxx> wrote in message
news:uTdm7M2YGHA.500@xxxxxxxxxxxxxxxxxxxxxxx
is there any limit to how long of a string SqlDataReader.GetString() can
return?






.