SQL-Server Text datatype

[ofsouto]

Hi, dear

I need to get the value of a text datatype collumn in a SQL-Server table.
The text length is 2196 characters, but when I try to get it by datareader or dataset the text
length is 696.
What's wrong? How can I get the full text?

Thank you very much.

Obede
Brazil

 

[meckeard]

How are you getting the value from the database? In-line (or imbedded) SQL or a stored prcedure?

Mark