CF Query appears to return incomplete data from text field

Question

I'm using CF8 and SQL2000. I'm storing a bunch of HTML in a Text field in my SQL table. When I do a simple CFQUERY against that data, and CFDUMP it, it's truncated to 64000 characters.

I've confirmed that my data is complete in the SQL table, by selecting the tail end of the data using SELECT Substring, and confirmed the length using SELECT Datalength(). It's really 65102 characters long.

Is this a limitation of CFQUERY, and if so, what's a good way around this?

Answer 1

This is a CF Administrator datasource setting.

Edit the datasource, view the Advanced section, and increase from 64,000 to an appropriate value.