SQL Data Encryption - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

SQL Data Encryption

Author

Topic

suchiate
Starting Member

33 Posts

Posted - 2007-03-11 : 04:24:12

Hi guys,

Can anyone guide me or provide references on how to encrypt and decrypt data in sql server? I am developing in .NET. Thanks in advance. Hope you guys can help me out.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-03-11 : 05:11:17

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=76258

Peter Larsson
Helsingborg, Sweden

suchiate
Starting Member

33 Posts

Posted - 2007-03-11 : 05:43:49

hey peso,

i have seen two of your threads on encryption and i think you did a great job in writing these encryption functions. I am trying to understand your MIME64 Encoding.. but one part I dont understand is that when you do m1=ASCII(SubString(plaintext, index, 1) & 252

what do you mean by & 252 with an integer ?

Hope you can guide me more into this, Thanks alot!

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-03-11 : 06:25:56

quote:
& (Bitwise AND)
Performs a bitwise logical AND operation between two integer values.

suchiate
Starting Member

33 Posts

Posted - 2007-03-11 : 07:28:22

thanks alot for your replies peso and khtan..

but do you guys have any reference to using binary encryption?

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-03-11 : 18:39:25

please note that encoding isn't encryption.
it can be simply decoded back to real text.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

ann
Posting Yak Master

220 Posts

Posted - 2007-03-11 : 19:50:31

this link will give you what you want (source code and explanation) - it uses a high level of encryption:

http://www.devx.com/dbzone/Article/26726/0/page/1

suchiate
Starting Member

33 Posts

Posted - 2007-03-13 : 00:02:30

Thanks alot for all your guidance =)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources