Hello,
 Is it possible to put custom encrypted content in a CLOB and then use a custom Word Generator or something for full text index the field ?

Thank you

Michael,

<< Is it possible to put custom encrypted content in a CLOB and then use a custom Word Generator or something for full text index the field ? >>

Sure, but you're going to want to also create a text filter module that can be used to decrypt the text before it gets handed off to the word generator:

Tim Young
Elevate Software
www.elevatesoft.com

Tim,

<< Sure, but you're going to want to also create a text filter module that can be used to decrypt the text before it gets handed off to the word generator:>>

Great! Is it safe to put "Binary" Data into the CLOB and do the same ?

Thank you

Up ...

Michael,

<< Great! Is it safe to put "Binary" Data into the CLOB and do the same ? >>

Not really - you're going to run into issues if you start trying to use binary data with the filtering.  The filtering is done across a C-style API into the DLL, so strings are dealt with as if they were NULL-terminated C-style strings.

Tim Young
Elevate Software
www.elevatesoft.com

Michael,

If the data is encoded as hex, etc., then yes, it will work then.  But not raw binary data.

Tim Young
Elevate Software
www.elevatesoft.com

I used to use UUEncode for things like that - fairly fast and a standard.

Roy Lambert

Thank you guys for thei ideas!