SqlDataReader and Text columns

  • Thread starter Thread starter paul.hester
  • Start date Start date
P

paul.hester

Hi all,

I'm using the SqlDataReader to read result rows returned from a stored
procedure. One of the columns is a text column containing values longer
than 8000 characters. I cannot find a way to get SqlDataReader to read
the entire value - it always cuts it off at 8000 characters.

I've tried GetString, GetSQLString and GetChars but they all cut the
value off. Does anyone know how to read text values using
SqlDataReader?

Many thanks,

Paul
 
Hi all,

I'm using the SqlDataReader to read result rows returned from a stored
procedure. One of the columns is a text column containing values longer
than 8000 characters.
Click to expand...
What database are you working with? (SQLServer? Oracle? Access?) What is
the size of the column (as defined in the database?)
How are you sure that that more than 8000 char are saved in the database
(maybe the problem is that they were truncated on saving)...

I cannot find a way to get SqlDataReader to read
 
Back
Top