3des encryption using DBA toolkit: encrypted data with strange characters

• Marc-Andre Leduc

  Newbie

  Points: 7

  More actions

  May 18, 2007 at 7:52 am

  #178993

  Hi,

  I'm new to data encryption and I'm having some problems encrypting data with the dba toolkit provided on sqlservercentral. The encryption and decryption process works fine, but my problem is that when I encrypt the data, the encrypted result contains un expected characters.

  For example, if I encrypt : "Hello, World!" with a certain key, I'll get a result like:  íîj¨&lh<

  When I decrypt it, I get the "Hello, World!" back, but the problem is that I want to transfer my encrypted data to a third party. The third party has the same key but they don't get the same result when they encrypt the same string.... I know that they are using Oracle but I guess that the 3des algorithm is standard so they should get the same result.

  I think that it could be something about encoding... I know that their encoding output after the encryption is hexadecimal but I'm not sure what type of encoding the toolkit uses... I also tried to decode the encrypted result with the XP_base64_decode procedure but I didn't get any good results with this...

  I'm on sql server 2000 and I uses the xp_encrypt_3des stored procedure to encrypt.

  Thanks for your help,

  Marc

• Steve Jones - SSC Editor

  SSC Guru

  Points: 740723

  More actions

  May 18, 2007 at 8:05 am

  #707456

  I sent this on to the author. My guess is the algorithms or the seed are slightly different.