You'll have to encrypt each column independently. If you use the same key and initialization vector, you should be able to search, but of course, only for exact matches. Also, the size of each field will probably grow to the next multiple of your cipher's block size, so you'll need to pad the data before you encrypt; and you'll have to remove nulls from the encrypted data. I think the sequence would have to be
Pad each field Encrypt each field Encode the nulls in each field Store the record -- Fetch the record Restore the nulls in each field Decrypt each field Remove the padding from each field Regards --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
