thanks again for your response basically the database contains a mixture of non-personal and personal data. our clients wishes to be able to select which columns are personal and are therefore encrypted (this is basically to satisfy data protection people)
the initial idea was to create a separate database and when the user clicked to 'secure' a column then our code would remove the column and move it to a seperate database. this of course would not solve the security issues so we dont really see the need to do this, so thought if we could just encrypt the data within the column then it would satisfy the relevant bodies i think creating a separate column would prob be the best way, unless you can think of an alternative we appreciate your feedback >>>how would i get around the issue of encypting data in integer >columns? - as some of the columns are set as smallint(2) for example. > >You need to create an extra column to contain the encrypted value. I >know no encrypting algorithm capable of encrypting a smallint into a >smallint, except may be an equivalence table, but can this still be >called "encryption". > > >>what do you think? > >Well, frankly, to be honest, before I think anything about this, I'd >like to know a little more about >the idea behind all this. >Why do you need to encrypt a column in the first time? >May be there is a better solution. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321413 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
