Re: cfqueryparam and mssql

["jeremy@noble" <webforumsuser@xxxxxxxxxxxxxx>]

Thanks for the help guys.

 I tried both and they both seem to work the same as far as I can tell. If the 
field is set to nvarchar they both input the same data. Entering one letter in 
a 255 length field still only stores as one letter.

 The only real value for me to use CF_SQL_CHAR is that it is just that much 
less typing! I have to update an old site with 450+ queries to use 
CFQUERYPARAM. Of course, most of them are nvarchar fields. I found a free 
script that updates your pages but uses the default CF_SQL_CHAR. It would be 
great to just use that and same me all the hassle.