[Message Deleted]
-
[Message Deleted]
-
[Message Deleted]
I am not sure how you are passing the binary type to the sp, I am guessing it is in error because you are passing a string to a binary field. Either convert it to binary when passing it to the sp or do a CONVERT(binary(16), @password) I don’t believe the SQL stage is the place where you want to build you cryptology, the application should send you a encrypted string. PS.. I assume this is MS SQL Server John
-
I am not sure how you are passing the binary type to the sp, I am guessing it is in error because you are passing a string to a binary field. Either convert it to binary when passing it to the sp or do a CONVERT(binary(16), @password) I don’t believe the SQL stage is the place where you want to build you cryptology, the application should send you a encrypted string. PS.. I assume this is MS SQL Server John
Hi, Thanks for the response. I realised i was entering a string rather than a binary. I was simplytesting the procedure in the SQL editor to test it in preparation for use with my website. The coding of the website passes in a hashed string, hence the SQL / procedure set-up. P.s. I did mention in the orginal post that it was an SQL2005 DB. I deleted the post once i realised my foolish mistake. Thanks again.