encryt function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

HandersonVA - 27 Nov 2007 21:40 GMT

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?

Reply to this Message

SafariTECH - 28 Nov 2007 15:45 GMT

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.

Reply to this Message

Webmaster Forum / ColdFusion / Advanced Techniques / November 2007

encryt function