December 5, 2005 at 9:14 am
Dear All
There is this comments filed in a table whose datatype is varchar(1000) but the problem is that I'm not able to save more than 255 characters in this.Even if I change the size to 2000 also then also I'm able to save only 255 chracters.Could anyone help me out to find the reason the for this.Is there any other setting by virtue of which u can only save 255 charcters in a column no matter even if the size is much more than that.
Also one more thing the total lenght of the ros is also well below the 8060 size.
December 5, 2005 at 9:42 am
Check the query analyser settings. There's one that "trims" the display to 255 characters. Just set that to the max value and you'll see your data at the next select.
December 5, 2005 at 9:48 am
Well tx a lot for that.But I will have to do that again and again or if i set it once it will be there.
The problem was that the guy who takes out the report was getting only the comments as 256 characters and so the problem came.Now if I once set the settings to 8000 will it be permananet or only till the time the connection is there.
December 5, 2005 at 9:54 am
What program are you using to present the data (that is causing that problem)?
Are you sure that there's more than 255 characters in the data you are seeing?
December 5, 2005 at 10:12 am
The guy takes out the report using query analyser only and yes there are more than 255 characters in the column.
December 5, 2005 at 10:54 am
Ok, then you'll have to set it only once for the query analyser. Note that this setting is local for each computer, so if the guy always switches around to see that data, then he'll have to reset it every first time he checks the report.
December 7, 2005 at 2:57 pm
Query Analyzer limits the output size by default to 256 characters as mentioned above. But, even though you can't see all of the data in the results set in QA does not mean that your column length was not long enough. You column was still the size that you created the column at, but QA just doesn't display it unless you change your result options.
You can find it under the menu item Tools/Options/Results Tab/Maximum characters per column: <field>
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply