Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 276
  • 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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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