Re: data length for encrypted data

2010-02-18 Thread Mike Chabot

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


data length for encrypted data

2010-02-18 Thread Matthew Smith

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:330887
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4