Hi.
DECLARE @EncryptedValue varbinary(MAX)
SET @EncryptedValue =EncryptByKey(Key_GUID('CreditCards_Key11'), '123')
select @EncryptedValue
declare @x varbinary(max)
OPEN SYMMETRIC KEY CreditCards_Key11
DECRYPTION BY CERTIFICATE Sales09;
SELECT @x = DecryptByKey(0x007F6D50FF656E4498FD19F55504E1530100000045DE7F65E9EB81C1108DBD519430A6DBAEDCCC59DC6B72174125CA475289F653)
select cast( @x as varchar(max))
If i do select cast( @x as nvarchar(max)) it will decrypt funny letters ( to varchar will work).
How would I go about and decrypt to nvarchar?
I have tried
OPEN SYMMETRIC KEY CreditCards_Key11
DECRYPTION BY CERTIFICATE Sales09;
-- SELECT EncryptByKey(Key_GUID('CreditCards_Key11'), '123αάΒΩ');
select EncryptByKey(Key_GUID('CreditCards_Key11')
, '123', 1, HashBytes('SHA1', CONVERT( nvarchar(max)
, '123')))
---decrypt
OPEN SYMMETRIC KEY CreditCards_Key11
DECRYPTION BY CERTIFICATE Sales09;
declare @x varbinary(max)
SELECT @x = DecryptByKey(0x007F6D50FF656E4498FD19F55504E153010000004FDA57244527B52806C7817B2782ECEBC49F540652F16025C8FDC0F0E7F45FFB8A776CADA88D034BD77D7AD5ACB8CE62,1,
HashBytes('SHA1', CONVERT( nvarchar(max)
, 0x007F6D50FF656E4498FD19F55504E153010000004FDA57244527B52806C7817B2782ECEBC49F540652F16025C8FDC0F0E7F45FFB8A776CADA88D034BD77D7AD5ACB8CE62)))
select cast( @x as nvarchar(max))
This will bring null
Thanks.