Answer the question
In order to leave comments, you need to log in
Decryptbykey returns an empty string. What could be the problem?
Good afternoon!
There was such a problem: the password encrypted with the encryptbykey function is stored in the database.
Applying decryptbykey to this field returns an empty string. Everything seems to be correct.
encrypted field varbinary (max), decrypted varchar (max), I open the key before the decrypt, but the string is still empty. I broke my whole head already)
SQL Server 2012
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question