Solved

the length of a "text" col in table

Posted on 1998-12-09
3
201 Views
Last Modified: 2010-03-19
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
Comment
Question by:lijin1
  • 2
3 Comments
 
LVL 2

Accepted Solution

by:
tschill120198 earned 200 total points
Comment Utility
this is a limitation of ISQL, ISQL/w, etc., not displaying more than the first 255 characters.
0
 
LVL 2

Expert Comment

by:tschill120198
Comment Utility
You can verify that all the text is there (more than 255) by BCP-ing out the data.
0
 

Author Comment

by:lijin1
Comment Utility
Thank you very much, tschill!
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now