November 12, 2002 at 11:34 am
When we run a select statement on a text field (ex. notes field in the employees table in the northwind database), it does not return all the information. It seems to get cut off at a certain point. How can we get the entire string to get returned?
November 12, 2002 at 12:02 pm
If you are using QA there is a results setting that specifies the maximum characters per column. It defaults to 256, but can be changed on the "Tools" - "Options" - "Results" tab.
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
November 12, 2002 at 12:11 pm
That worked for Query Analyzer, but how about for a select statement from a application or web page?
quote:
If you are using QA there is a results setting that specifies the maximum characters per column. It defaults to 256, but can be changed on the "Tools" - "Options" - "Results" tab.Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
November 12, 2002 at 12:22 pm
Are you having the same problem with your web page, and/or application? Have you looked at your @@TEXTSIZE setting?
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
November 12, 2002 at 12:37 pm
Same problem. The @@TEXTSIZE says 64512.
quote:
Are you having the same problem with your web page, and/or application? Have you looked at your @@TEXTSIZE setting?Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
November 12, 2002 at 12:45 pm
What method are you using to connect to SQL Server?
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
November 12, 2002 at 2:12 pm
We use ADO connection object.
quote:
What method are you using to connect to SQL Server?Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
November 12, 2002 at 2:25 pm
Might try looking at the "Managing Long Data Types" section of BOL for some ideas.
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
November 12, 2002 at 3:01 pm
I havwe never had trouble with this in ASP on VARCHAR or CHAR datatype of 8000 length(never needed to do text types).
Check the source code of the page to see if anything unusuall is there. For instance if you display the output in an INPUT type of TEXT and set the value if you use either the ' or " to delimit the ends and you have one in your output you will break out of the code casuing it to not all appear. To fix you have to double the one in the text.
November 12, 2002 at 3:38 pm
Funny story. I didn't get all the info from my developer and it turns out that it is Access that is truncating the data. (long story). Anyway, it's nice to know that I can get info quickly here. Thanks for everyone's help.
quote:
I havwe never had trouble with this in ASP on VARCHAR or CHAR datatype of 8000 length(never needed to do text types).Check the source code of the page to see if anything unusuall is there. For instance if you display the output in an INPUT type of TEXT and set the value if you use either the ' or " to delimit the ends and you have one in your output you will break out of the code casuing it to not all appear. To fix you have to double the one in the text.
Viewing 10 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply