Re: cfqueryparam and mssql

[PaulH **AdobeCommunityExpert** <paul@xxxxxxxxxxxxxxxxxx>]

jeremy@noble wrote:
> I'm a little confused about using cfqueryparam:
>
>  I know the defualt CFSQLTYPE is CF_SQL_CHAR. Most of my fields are nvarchar, 
> so would I HAVE to use CF_SQL_VARCHAR? Or would CF_SQL_CHAR work as well?

use varchar & make sure you set the "Enable High ASCII characters and Unicode 
for data sources configured for non-Latin characters" under advanced settings 
for that dsn.