RC4 encryption/decryption with SQL Server

  • SwePeso

    SSC-Dedicated

    Points: 39693

    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"

  • balvinder.saini

    Valued Member

    Points: 74

    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?

  • nmah

    SSC Rookie

    Points: 38

    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!

  • nrkrspatel@yahoo.com

    Valued Member

    Points: 53

    Can any one provide this same implementation for Hex values?

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

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