Decrypted Value Is Different From The Original One

Hi,

I got an issue with encrypt and decrypt. I encrypted a data, say 'ok', then I decrypt the encrypted data, but what I got is not 'ok'. but if I encrypt a column, then after decryption, those data asr same with the original data in that column.



In my case,



...

create table mytable ( column Password varbinay(128) )

...

create symmetric key with certificate

...

OPEN SYMMETRIC KEY Sym_Key_01

DECRYPTION BY CERTIFICATE Cert;



UPDATE mytable

SET Password = EncryptByKey(Key_GUID('Password_01'),'ok')



select CONVERT(nvarchar, DecryptByKey(Password)) AS "Decrypted Password" from mytable



here, I didn't get the value 'ok' but a another wierd word (like a chinese word).



does someone know the reason?



Thanks,



Jone