ADO.NET SQL-Server Text data type

[ofsouto]

Hi, dear

I need to get the full text of a text datatype collumn of a sql-server table.
I tried the example of this link (

http://www.kbalertz.com/Feedback_317034.aspx)

and change getbytes to getchars and I didn't get the full
text. What's wrong? How can I get the full text?
Thank you very much.

Obede
Brazil

 

[shatch]

Can you please let us know what you are trying to do with this, are you writing it out to a file? If this is the case, would it be easier to hold it in an image type field which allows you to access the stream?

 

[ofsouto]

Hi, dear

I just got full text but there are some chr(13) characteres inside text. I think I'm using wrong encoding.

Obede
Brazil

 

[shatch]

If you are rendering this to a page in ASP.net you will need to replace all chr(13) with "<BR>", if thats not the problem, what exactly are you getting with regards to errors or badly displayed text?