Exploring the Varbinary Type

  • TimothyAWiseman

    SSCrazy Eights

    Points: 8819

    Comments posted to this topic are about the item Exploring the Varbinary Type

    ---
    Timothy A Wiseman
    SQL Blog: http://timothyawiseman.wordpress.com/

  • Albert van der Ploeg

    SSC Rookie

    Points: 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

  • BarneyL

    Ten Centuries

    Points: 1044

    Similarly to Albert the main use I've come across for binary data types is check sums generated by the hashbytes function.

  • TimothyAWiseman

    SSCrazy Eights

    Points: 8819

    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 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply