Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

RC4 encryption/decryption with SQL Server Expand / Collapse
Author
Message
Posted Thursday, September 27, 2007 2:29 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, July 18, 2014 6:22 AM
Points: 2,393, Visits: 3,398
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"
Post #403731
Posted Wednesday, January 2, 2008 7:31 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, December 2, 2008 2:59 AM
Points: 2, Visits: 19
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?
Post #438212
Posted Friday, February 1, 2008 7:18 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, September 26, 2008 10:00 AM
Points: 6, Visits: 11
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!

Post #450840
Posted Monday, March 29, 2010 12:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 4, 2012 3:29 AM
Points: 9, Visits: 56
Can any one provide this same implementation for Hex values?
Post #891601
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse