 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / General / Security / April 2006is there any limit to how long of a string SqlDataReader.GetString() can return?
is there any limit to how long of a string SqlDataReader.GetString() can return? Only 8000 characters. No more Nathan H. Omukwenyi > is there any limit to how long of a string SqlDataReader.GetString() can > return? I don't believe there is a limit other than available memory.  SignatureHope this helps. Dan Guzman SQL Server MVP > Only 8000 characters. No more > > Nathan H. Omukwenyi > >> is there any limit to how long of a string SqlDataReader.GetString() can >> return? 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. > 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 >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. > >> is there any limit to how long of a string SqlDataReader.GetString() can >> return? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.