I have a table with both varchar and ntext fields types. I recently converted a varchar(300) field to ntext. I can store 1000+ chars in this field and see all of them when browsing using something like an Access ADP file but a select statement or crystal report will only return the first 255 chars. Other ntext fields in the same table return more than 255 chars. Why can't I retrieve all of the ntext field in Query Analyzer or Crystal?
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.