SqlDataReader and Text columns

21 Nov 2005 11:03 PM

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

22 Nov 2005 5:05 AM

luxspes

paul.hes***@gmail.com wrote:

> 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
Show quote

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