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.
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#596I 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=0x000A45397C738846879A1A3E2FED78720100000005814AA656AF7990648901AEB731C095A8180B667EE44C13what 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" |
|
|
chamberssh
Starting Member
6 Posts |
Posted - 2010-08-20 : 06:51:33
|
great thanks |
|
|
|
|
|