RC4 encryption/decryption with SQL Server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Peter Larsson » RC4 encryption/decryption with SQL Server

RC4 encryption/decryption with SQL Server

Rate Topic

Display Mode

Topic Options

Author

Message

SwePeso

Posted Thursday, September 27, 2007 2:29 PM

SSCrazy

Group: General Forum Members
Last Login: Thursday, May 30, 2013 1:26 PM
Points: 2,359, Visits: 3,293

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

balvinder.saini

Posted Wednesday, January 02, 2008 7:31 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, December 02, 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

nmah

Posted Friday, February 01, 2008 7:18 PM

Forum 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

nrkrspatel@yahoo.com

Posted Monday, March 29, 2010 12:56 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, October 04, 2012 3:29 AM
Points: 9, Visits: 56

Can any one provide this same implementation for Hex values?

Post #891601

« Prev Topic | Next Topic »

Permissions