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>