SqlDataReader and Text columns

[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

 

[luxspes]

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.

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