[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 277
  • Last Modified:

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!
0
lijin1
Asked:
lijin1
  • 2
1 Solution
 
tschill120198Commented:
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now