CODEWITHSUNDEEP
sql-server-2008
Indu
Indu

Reputation: 27

How can I convert an encrypted data as string and decrypt the data in SQL Server 2008

How can I convert an encrypted data as string and decrypt the data in SQL Server 2008?

I have tried the following

Encrypt data:

SELECT 
   CONVERT([varchar](512), EncryptByPassPhrase('Nessis22',CONVERT(NVARCHAR(MAX), '6234')), 2)

Result : 

0x01000000F2AA862E820415737E99B1EDA7D3EF47225DAA898A744B118908BE626EE2510E

Decrypt data:

SELECT 
   CONVERT(VARCHAR(MAX), DecryptByPassPhrase('Nessis22'
, 0x01000000F2AA862E820415737E99B1EDA7D3EF47225DAA898A744B118908BE626EE2510E))

Output:

(No column name)
6

Data got truncated. How can I get complete string?

Upvotes: 1

Views: 3293

Answers (1)

Rubik
Rubik

Reputation: 1471

Use NVARCHAR within your decrypt SELECT:

select convert(NVARCHAR(max),DecryptByPassPhrase('Nessis22'
, 0x01000000F2AA862E820415737E99B1EDA7D3EF47225DAA898A744B118908BE626EE2510E))

Upvotes: 2

Related Questions