sql server ntext fields only display first 255 characters
Posted on 2004-10-20
I have a report built with CR 9.0 that has multiple ntext fields. The fields that were originally defined as ntext show in their entirety. The fields that were originally varchar and were later converted to ntext only show the first 255 characters. I've tried verifying the database and pointing to another datasource with no luck. If I run a query in Query Analyzer, Access, etc. I get all the text returned.