>I will ask the question everyone else seems to be afraid to ask.... >What is this data (obviously, don't tell us anything secret, just a vague >understanding like it's personal medical info or maybe the datatype...) you >are trying to search on and why is it encrypted?
It's a Notes field. We're becoming a certified school and during the process we wish to keep notes about our progress. If it's not encrypted, people might not write whatever they really think for fear of someone looking over the db which has a good chance of happening during a certification process. But the real reason is cause my boss told me to encrypt it. >Also, how large is the databse you are searching, if the datset is small >enough you could in theory select * and decrypt the data and then Query of >Queries on the decrypted data. Don't do this if it's a large recordset, the >performance issues would be massive. Well we'll have records as entered. It's a set of notes about a process. Later there'll be more - probably under 20,000 in the end. I'd like the process not to get longer as the years go on. I was suggested another solution and I think it's okay but would like opinions. It's to make an alternate Notes field and capitalize it so that I can search on encrypted uppercase to encrypted uppercase so that it's case-less. I'd have a Notes_U field in this case. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258879 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
