Note:- This question has some relation with the question "http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_27322186.html
The above attached SQL QUERY / ENCRYPT ALGORITHM QUERY is working fine if the PLAIN TEXT length is less than or equal to 30.
If the PLAIN TEXT length is greater than 30 then, the ENCRYPTION or DECRYPTION algorithm truncates the remaining characters.
How can I solve this issue?
I want to encrypt and decrypt 255 length PLAIN TEXT. Is it possible or not?
If possible, please let me know the sample code.
Othewise, please let me know the alternate solution with sample codes.