Cryptography application block saving to sql 2005

Topics: Cryptography Application Block
Jun 6, 2013 at 3:55 AM
Hi,

I'm working with ent lib 4.1, what I'm doing is im encrypting a plaintext then saves it to the database. For some reason its getting truncated when saving.

ex:

this is what should be saved:
5Mouxbyt0N0TZcV69mmk3cKeFBxVqO8Cbf8KikgVqKDbJF5k9nMukt6l6YNZnkIr

I have this in my column:
5Mouxbyt0N0TZcV69mmk3cKeFBxVqO8Cbf8KikgVqKDbJF5k9n

The data type of the column is (nvarchar(255))
I'm using "RijndaelManaged" to encrypt the plaintext.

Please tell me what I'm doing wrong.

Thanks,
bananaman
Jun 6, 2013 at 4:34 AM
I figured out, it was my SP that's messing it up.

this thread helps
https://entlib.codeplex.com/discussions/17857

Thanks