February 7, 2013 at 12:01 am
Comments posted to this topic are about the item Exploring the Varbinary Type
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
February 7, 2013 at 5:40 am
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
February 7, 2013 at 9:29 am
Similarly to Albert the main use I've come across for binary data types is check sums generated by the hashbytes function.
February 7, 2013 at 3:01 pm
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/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply