Description of Issue
By default, when creating a new SQL Server datasource in ColdFusion-MX, a query that retrieves content from a text or ntext field is limited to 64,000 characters. This will cause problems with large text fields in WSP. This article provides the correct setting for the CFMX SQL DSN to alleviate this issue.

This problem may be more evident in WSP than in other databases as large text fields are stored in the database with a data-type of "ntext," which support the UniCode double-byte character set. As a result, if the maximum number of characters allowed in the DSN settings is set to 64,000, it will appear that you only received 32,000.

Anytime a ntext field exceeds the setting in the CF DSN, the extra characters are truncated.

Resolution
Change existing CF datasources for the WSP site databases as follows:

1. Log into the ColdFusion Administrator on the server running WSP.

2. Select the "Data Sources" option in the left navigation, located under the "DATA & SERVICES" heading. The list of configured datasources will be displayed.

3. Click on a WSP site datasource, which will display a settings dialog similar to the following:

4. Click on the "Show Advanced Settings" button to see the advanced configuration options, similar to the following:

5. In the area highlighted above, make sure you check the CLOB field. This will override the character limitation for ntext fields.

Note: Different web browsers have differing limitations on the amount of text support in a <TEXTAREA> and/or <INPUT> field. This change does NOT resolve issues involving browser limitations.