tracker issue : CF-3844624

select a category, or use search below
(searches all categories and all time range)
Title:

Unable to insert unicode character ' ñ ' in SQL Server 2014 using cfquery

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/CannotReproduce

Reporter/Name(from Bugbase): / ext-user (Nimit Sharma)

Created: 10/29/2014

Components: Database, JDBC

Versions: 11.0

Failure Type:

Found In Build/Fixed In Build: 291742 /

Priority/Frequency: Normal / Few users will encounter

Locale/System: English / Mac 10 All,Win XP All

Vote Count: 0

Problem: Unable to insert unicode character in SQL Server 2014 using cfquery

It works fine with SQL Server 2012.

I have tried using DD driver and microsoft sql server driver with java code and it works fine.

Code snippet:

<cfquery name="q" datasource="#regdatasource#">
INSERT INTO #tbl# VALUES ( 
	<cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="Spanish">,
	<cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="Español">
)
</cfquery>

Method:

Result:

Expected:

Workaround:

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3844624

External Customer Info:
External Company:  
External Customer Name:  
External Customer Email:

Attachments:

Comments: