How do I see the data in a varchar field greater than 800 characters in length?
-
How do I display a field with more than 800 characters?
We have a varchar(4000) field and and when we select from the table we only see the first 800 characters in SQL Query Analyzer or when we run a stored procedure, it cuts off at 800 chars as well. If you open the table in MS Access, we can see all the contents. We are trying to add the field to ASPX web page but it cuts off at 800 as well. Any ideas?
-
In QA, go to menu Tools => Options => (tab) Results and set "Maximum characters per column" to a greater value.
/Kenneth
-
Thanks and it works perfectly for query analyzer! But how would you get it to return more than 800 chars in a stored procedure linked to a aspx web page? The length limit seems to be on that as well? Any ideas? Any help would be greatly appreciated.
-
Somewhere between the db and asp page there is a layer that has the same type of truncation of length...
Have no clue what or where though...
/Kenneth
-
its ur recordset method, try changing that to accept a large string, or maybe
ur textbox set it to multline
debug the application
check the value of the field how much is it throwing
<a href="http://www.websolsoftware.com"> For IT jobs click here</a>
*Sukhoi*[font="Arial Narrow"][/font]
-
convert the datatype to text of the column in the select statement.
might be not the best of the solutions
hth...
Regards,
Sachin Dedhia -
Have you tried to use substring in your select...
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply