Any options to set column length in query?

• Jinsong Jin

  Old Hand

  Points: 389

  More actions

  December 17, 2003 at 6:04 pm

  #65753

  I created a report using CR 8.5, connecting a small table(only 10 records)which has a char(6000) column in SQL Server through ODBC.

  My problem is:

  when this report runs on Windows 2000 & SQL Server 2000, it can show up all characters stored in that char(6000) column;

  but on Windows NT 4 & SQL Server 7, char(6000) column has been truncated, CR only shows up around 1028 characters.

  I am just wondering:

  Is thers any options I can set, no matter in SQL server 7, Windows NT or CR, to let the qeury get a 6000 characters column back?

  Thanks,

• Jinsong Jin

  Old Hand

  Points: 389

  More actions

  December 18, 2003 at 4:03 pm

  #487109

  I worked around the weird.

  Couldn't find anything valuable on options of SQL Server, ODBC, NT and CR.

  I put all those 10 big strings on CR while only showing one every time.

  Thank you for looking at my question.

  Edited by - gemsun on 12/18/2003 4:03:46 PM