Download ODBC Drivers for Oracle, SQL Server, Salesforce, MongoDB, Access, Derby, InterBase & DB2.

Easysoft JDBC-ODBC Bridge

My SQL Server NCHAR and NVARCHAR datatypes not displayed correctly by the Coldfusion MX <CFOUTPUT> tag. What can I do?

Article:
00782
Last Reviewed:
19th January 2024
Revision:
1

A possible workaround is to CAST the column as a VARCHAR in the SQL, for example:

<CFQUERY name="ds" datasource="JDBC-ODBC Bridge">
    SELECT CAST(field1 AS varchar(100)) AS field1 FROM nchartest
</CFQUERY>

<CFOUTPUT query="ds">
    Output="#field1#"
</CFOUTPUT>
Applies To

Knowledge Base Feedback

* Did this content help you?
* Please select one option based on your first choice:

(* Required Fields)