Column Length

[jbolger]

Hi,

Does anyone know what column length I would need to specify for an encrypted string column that allows users to enter 1000 characters?

I see that encrypted strings still retain a default column length of 255 chars(Oracle db) but how many characters can the user then enter without the app falling over?

I am using PBEWITHSHA256AND256BITAES-CBC-BC

Thanks very much
John

[subversion]

very helpful information can be found from http://www.obviex.com/Articles/CiphertextSize.aspx