I wasn't even sure the best way to title this post but here's the problem.

Using CFFILE I've imported entire web pages into my SQL Server DB.

If I go into Studio Express and copy the data out and paste it into Homesite, I see all the data (the complete page).

However, if I try to get CF to display it, some records get truncated. It seems to cut off at a LEN of 64000.

CF Functions also cut off at that point. For example if I do a FIND for a known string near the end of the content, it comes back with a 0.

Any help would be most appreciated, as I'm stumped.

Enabled CLOB under Advanced Datasource settings and all is well.