cfprocparam sending "???????" to SQL Server

[1dermom]

I have a SQL Server stored procedure that expects an nvarchar parameter. The
cfprocparam is sending Russian characters, but the stored proc seems to be
receiving only question marks. Ordinarily, an n-prefix should be used to send
the unicode string, but I get a CF error when I try that in the cfprocparam
value. Incidentally, the n-prefix works fine if I send the data as SQL string
in a cfquery.

Can anyone shed some light?

<cfstoredproc procedure = "spGetJobList"
datasource="Training_Integration_Tracking" dbtype="odbc" returnCode = "No">
<cfprocresult name = "rs1">
<cfprocparam type = "IN" CFSQLType = "CF_SQL_LONGVARCHAR" value = "#MyTitle#">
</cfstoredproc>

[PaulH]

first off, you should be using the JDBC driver not the odbc one.

turn on the
[url]http://www.sustainablegis.com/blog/cfg11n/index.cfm?mode=entry&entry=F9553D86-20[/url]
ED-7DEE-2A913AFD8651643F for that dsn. that should do the trick.

[1dermom]

The "unicode option" is something that is specified by the person who defines the dsn on the server?

[PaulH]

yes.