Coldfusion, MS SQL, Hash Best Practices,...
hello,
i trying trying store hashed data (user password) in ms sql database; datatype in database set varbinary. datatype conflict when trying insert hashed data. works when datatype in database set varchar.
i understand can set hash function arguments convert data before sending database, not clear on how done. now, along assistance conversion, best practice storing hash data? should store varcahar or varbinary? of course, if varchar won't have problem, interested in best practices well.
thnx
i trying trying store hashed data (user password) in ms sql database; datatype in database set varbinary. datatype conflict when trying insert hashed data. works when datatype in database set varchar.
i understand can set hash function arguments convert data before sending database, not clear on how done. now, along assistance conversion, best practice storing hash data? should store varcahar or varbinary? of course, if varchar won't have problem, interested in best practices well.
thnx
just curious... using cfqueryparam tag cfsqltype="cf_sql_varbinary"?
phil
phil
More discussions in Getting Started
adobe
Comments
Post a Comment