Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 fetching text column

Author  Topic 

sujith
Starting Member

20 Posts

Posted - 2005-06-24 : 08:48:47
i have used one text column in my table but at the time of retreving table gives me only first 255 characters :(

anybody knows how to retrieve entire text

Sujith

Sujith S

Help Desk
Starting Member

10 Posts

Posted - 2005-06-24 : 08:50:46
Read up on READTEXT to read and WRITETEXT to write.

www.dotdesk.com Help Desk
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-06-24 : 08:51:06
i guess you mean in QA:
Tools-Options->Results tab-> maximum char per column
set to 8000. that's the max.

Go with the flow & have fun! Else fight the flow
Go to Top of Page

sujith
Starting Member

20 Posts

Posted - 2005-06-27 : 01:54:31
i used READTEXT but still the problem is not solved
i have textcolumn record of say 10,000 characters but
while retreving the text it is giving me only 256 char.
what do i do?

Sujith S
Go to Top of Page
   

- Advertisement -