Note that ISQL is a different cmdline version (in 7.0). ISQLW is the 7.0 GUI
tool and the equivalent in 8.0 is QA (but executable is still isqlw.exe for
Regarding crystal reports I remember that you can set properties for max.
display characters. Maybe this has the same default. Double-click on the
field and check settings.
> Isn't it a pseudo - truncate due to ISQL Settings?
> Did you try to go to Menu -> Query -> Current Connection Options ->
> Advanced -> Maximum characters per column. There is the 256 default
> settings for data display in ISQL Results window. Set this to more...
> About Crystal Reports.. I had the same problem: data being truncated
> at display only even if inside database I had the right text.
> --hope it helps
> > QA has a default max. textsize limit of 256. To change this go to
> > Tools/Options and select tab 'Results' and change 'Maximum characters
> > column' (max 8192).
> > > I've noticed this also, and I think it is that the Query Analyser
> > truncates
> > > the *output*. Dont quite get what is going on in Crystal reports
> > > that should show all your data. A quick thing to try is to link up
> > MS
> > > Access, and seeing if that will show the data without truncation, it
> > > normally shows it ok. Also, try:
> > > SELECT MAX( LEN( myTextCol ) ) FROM aTable
> > > This should tell you if data is being truncated.
> > > Incidentally, I've also noticed that if you do a CAST( afield AS
> > > the default length is 256, so data gets truncated there.
> > > Tobin
> > > > In SQL server 7.0, I have a column that is nvarchar(2000).
> > > > I have text in this field that is about 368 characters long.
> > > > Only 256 characters display in query analyzer. I first noticed this
> > > > problem in a report I created using Crystal Reports, then thinking
> > > > was a problem with Crystal. But while doing my research, I noticed
> > > > this similar behavior in the query analyzer.
> > > > Does anyone know if there is a setting that must be tweaked or what?