RC4 encryption/decryption with SQL Server

  • Comments posted to this topic are about the item RC4 encryption/decryption with SQL Server


    N 56°04'39.16"
    E 12°55'05.25"

  • got a issue with this one..im not sure why..

    My results are as follows:

    Select dbo.fnEncDecRc4('Orange12345', 'Hello123')

    Output : ,Mgl

    Select dbo.fnEncDecRc4('Orange12345', ',Mgl')

    Output : M

    i am not able to decrypt it. Any idea why this is hapenning? Does it has to do something with regional settings?

  • I found only one issue....I've got a field in my db table that is encrypted for all rows. When I do my 'select' to retrieve data on my webpage in old asp, it actually changes the value in the db table back to descrypted and stores it in the database!

  • Can any one provide this same implementation for Hex values?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply