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?
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how does ado.net SqlDataReader.GetString() know which encoding to read the data into a string as? Do 1
ADO.NET questions: DbType.Text -- set/get example...? 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
how to determine what language a c# string is written in? is there any C# method to take a string an 3
How to create mutliple instances of Tracert in VB.NET to run at thesame time 2
Long strings 2
MS ACCESS 2013 Long Text filed filter by another tables Long text field 1
Is there any Hard drive size limit in XP? 11

Back
Top