SQL Server NCHAR and NVARCHAR datatypes are not displayed correctly by Coldfusion MX <CFOUTPUT> tag.

Easysoft JDBC-ODBC Bridge

SQL Server NCHAR and NVARCHAR datatypes are not displayed correctly by Coldfusion MX <CFOUTPUT> tag.

Article :	00782
Last Reviewed :	19th July 2005
Revision :	1

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

<CFQUERY name="ds" datasource="JOB">
SELECT CAST(field1 AS varchar(100)) AS field1 FROM nchartest
</CFQUERY>

<CFOUTPUT query="ds">
Output="#field1#"

</CFOUTPUT>

Applies To

Products
- Easysoft JDBC-ODBC Bridge
Applications
- ColdFusionMX

*	Did this content help you? Yes No Maybe

*	Please select one option based on your first choice: I'm very satisfied I think it will help, but I haven't tried it yet It is helpful, but I need more information It is helpful, but hard to understand Seemed relevant in search results, but didn't help me The information is incorrect The page contains one or more broken links

	Suggest new content or let us know how we can improve this content:

	(* Required Fields)

Easysoft JDBC-ODBC Bridge

SQL Server NCHAR and NVARCHAR datatypes are not displayed correctly by Coldfusion MX <CFOUTPUT> tag.

Applies To

Knowledge Base Feedback