the length of a "text" col in table

I define a col with data type "text" in a table, after insert a text more than 255 chars, select from that col it can only display 255 chars,what can I do to store more than 255 chars to the col, or this is only a matter of "select"?
Thank you very much!
lijin1Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
tschill120198Connect With a Mentor Commented:
this is a limitation of ISQL, ISQL/w, etc., not displaying more than the first 255 characters.
0
 
tschill120198Commented:
You can verify that all the text is there (more than 255) by BCP-ing out the data.
0
 
lijin1Author Commented:
Thank you very much, tschill!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.