Enable CLOB in DataSource in ColdFusion administrator / [Macromedia][SQLServer JDBC Driver][SQLServer]XML parsing: line 1, character 64000, equal expected

ERROR:   Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]XML parsing: line 1, character 64000, equal expected  

CASE:  we get this error when we try to retrieve long text/characters from database in cfquery.   Default configuration for Long Text Buffer (chr) is 64,000. when you expect result more than 64,000 characters in CFQUERY then we need to enable  "Enable long text retrieval (CLOB)". 

see below image for reference