Much longer.... The actual answer depends on a number of factors. Instead of going down that path, the easiest thing to do is to use a varchar(5000), insert all the data, use SQL to figure out the max length, then shrink the column width.
-Mike Chabot On Thu, Feb 18, 2010 at 2:55 PM, Matthew Smith <chedders...@gmail.com> wrote: > > I will be encrypting data using aes within sql server., > > If the plain text field is nvarchar(100), how long should the encrypted > field be? > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330888 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4