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 2008 Forums
 Transact-SQL (2008)
 Unsafe chars in SS 3DES encryption?

Author  Topic 

chamberssh
Starting Member

6 Posts

Posted - 2010-08-19 : 07:11:07
Hi,

I have used SQL Server's encryption to encryt/decrypt certain column data.

i.e. as in the article: http://dotnetslackers.com/articles/sql/IntroductionToSQLServerEncryptionAndSymmetricKeyEncryptionTutorial.aspx#596

I then include this decrypted value to send an email using database mail (using the encrypted values), thus an example:

hi.
please click on link
response.aspxid=0x000A45397C738846879A1A3E2FED78720100000005814AA656AF7990648901AEB731C095A8180B667EE44C13

what I need to know is : does sql server encryption method used contain any unsafe chars that will cause an issue in the querystring, i.e. like \ or &?

BTW in my sql server setup i use des3, i.e.:

CREATE SYMMETRIC KEY TestEncryptKey
WITH ALGORITHM = TRIPLE_DES
ENCRYPTION BY CERTIFICATE TestEncryptCert

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2010-08-19 : 07:53:14
Only if you used the "unsafe" characters when encrypting the value.
With that I mean the ASP page doesn't decrypt the value.
You have to do that yourself inside the page.


N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page

chamberssh
Starting Member

6 Posts

Posted - 2010-08-20 : 06:51:33
great thanks
Go to Top of Page
   

- Advertisement -