1 Reply Latest reply on Nov 28, 2007 7:44 AM by SafariTECH

    encryt function

      SSNs are stored as datatype nvarchar(11) on sql server 2005 . I'd like to encrypt them in database and decryt them to display on the browser. what datattype should setup in sql server 2005 when I encrypt 11 characters?
        • 1. Re: encryt function
          SafariTECH Level 1
          Part of it would depend on the algorithm and key used to encrypt the information. Your result could be anywhere from 11-to-hundreds of characters.

          If you want to be ultra safe, use ntext, but otherwise use a nvarchar set to a somewhat high level.