Thanks, James. I understand what you're saying. I'll just have to get some clarification from the client re: encryption.
So if I encrypt a document that is being uploaded by a user, I have to decrypt it, index it and then encrypt it again before I insert it into the database table? Can Oracle really index docs individually before inserting them into the database? I thought with SQL Server at least that you could either do full or incremental full-text indexes (timestamp required) and only after the doc is inserted into the table. Would that mean I'd have to store the doc, update the full-text index incrementally using a trigger, and then somehow encrypt it in the table? Thanks, Peter > I'm more familiar with Oracle, which will index a PDF as long as the > text is actually text (OCR'd or otherwise). If SQL server can index a > PDF doc, then it will be the same. > > Any tool that is going to index an encrypted doc needs to decrypt it > to do so, or you need to index the doc before encryption. Either way, > the index will be unencrypted so it will reveal the contents of your > encrypted docs on inspection (albeit in an obscure way). > > On 6/2/06, Peter Legg <[EMAIL PROTECTED]> wrote: > > James, another question for you... > > > > Do you know if scanned docs that are converted to PDF using OCR can > be full-text indexed and searched in SQL Server 2000? > > > > You said that encryption of docs prevents then from being full-text > indexed natively. Are there non-native products that can index > encrypted docs? > > > -- > CFAJAX docs and other useful articles: > http://jr-holmes.coldfusionjournal. com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242114 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
