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

My SQL Server NCHAR and NVARCHAR data types aren't displayed correctly by the Coldfusion MX <CFOUTPUT> tag. What can I do?

A possible workaround is to CAST the column to a VARCHAR in your 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>