Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Exploring the Varbinary Type Expand / Collapse
Author
Message
Posted Thursday, February 7, 2013 12:01 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, November 24, 2014 4:29 PM
Points: 752, Visits: 920
Comments posted to this topic are about the item Exploring the Varbinary Type

---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
Post #1416826
Posted Thursday, February 7, 2013 5:40 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, September 8, 2014 3:05 AM
Points: 1, Visits: 47
Timothy

I never used the type before, but working with it now in a project. This project requires encrypted fields in the database for privacy-sensitive information.

I'm using ENCRYPTBYPASSPHRASE for that now and as you might guess this function transforms varchar data into varbinary type.
I think this type of encrypted storage will become more and more important!

Regards
Albert
Post #1417000
Posted Thursday, February 7, 2013 9:29 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 6:31 AM
Points: 454, Visits: 783
Similarly to Albert the main use I've come across for binary data types is check sums generated by the hashbytes function.
Post #1417185
Posted Thursday, February 7, 2013 3:01 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, November 24, 2014 4:29 PM
Points: 752, Visits: 920
Albert and Barney, thank you for the comments. Storing checksums and encrypted data are definitely good use cases for the varbinary data type.

---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
Post #1417366
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse