Encrpted Columns in Table

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Recent Posts

Popular Topics

Home

Home » SQL Server 2008 » SQL Server 2008 - General » Encrpted Columns in Table

Add to briefcase

Encrpted Columns in Table

Expand / Collapse

Author

Message

Posted Monday, November 05, 2012 2:56 AM

Valued Member

Group: General Forum Members
Last Login: Friday, February 22, 2013 9:22 AM
Points: 63, Visits: 224

When I run the following it only returns one character for the surname field.

Any Ideas why I'm not geting the full surname.

USE Encrypteddb
GO
OPEN MASTER KEY DECRYPTION BY PASSWORD = 'Masterkeypassword'
OPEN SYMMETRIC KEY EncryptionKey
DECRYPTION BY CERTIFICATE EncryptionCertificate;
SELECT CONVERT(VARCHAR(500),DECRYPTBYKEY(surname)) AS surname, *
FROM dbo.encrypted_table
GO

Post #1380943

Posted Monday, November 05, 2012 3:57 AM

Valued Member

Group: General Forum Members
Last Login: Friday, February 22, 2013 9:22 AM
Points: 63, Visits: 224

The surname column is varbinary(200) in the table.

Post #1380965

Posted Monday, November 05, 2012 9:11 AM

Valued Member

Group: General Forum Members
Last Login: Friday, February 22, 2013 9:22 AM
Points: 63, Visits: 224

Coverting to Nvarchar resolved the issue.

Post #1381144

« Prev Topic | Next Topic »

Add to briefcase

Permissions

Expand / Collapse