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

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 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

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

Applies To

Knowledge Base Feedback