Encryption data types...

[fstyles]

I am trying to encrypt some cookie info and have that part working no problem. It is just when I try to store the initialization vector in the DB then use it again am I running into problems.

I'm not sure if the initialization vector is binary data or not and so when I retrieve it from the DB it comes back out ok and decrypts what I need decrypted just fine, but the decrypted info appears to be all binary junk...

Anyone played with encryption and dealt with IV's in a database before? I'm using 128 bit Rijndael/CBC.

Thanks.

[fstyles]

Well, an update:

It appears that by converting the IV (which does appear to be binary data) to a hexidecimal value and then storing it in a varchar(40) field, I can in fact retrieve the original and valid IV.

But it still won't convert the cookie back to the original data properly. It looks like binary junk still...

Still working on it...

[fstyles]

Well, I figured it out. It was to do with the hexidecimal vs binary data type issues. I was converting everything to hex to store in the cookie and DB, but somewhere along the lines I was not converting the original cookie value (that was hex) back to binary. I was using a binary VI on a hexidecimal cookie value... doh!

Anyway, hope this helps someone. Cheers.