[rt-users] Oracle Issue

[John Gedeon]

I have rt 2.0.15 working with Oracle, and I recently found out you cant do 
text searches on the Clob datatype. I am looking into solving this since we 
can't go production with out the ability to search the body of tickets. I 
figure we could use a varchar2() as the datatype but that limits us to (i 
think ) 4,000 characters. So that leaves the question what if the email is 
longer. My idea is to have two fields for the body and if its longer than 
4,000 the rest goes in the other field. How complex would that be to add? 
How would that effect how rt processes the searching of the tickets? any 
different ideas?

Thanks for any info
John


--
<>< Proverbs 3:5-6 "Trust in the Lord with all your heart and lean not on 
your own understanding;
                               in all your ways acknowledge him, and he 
will make your paths straight."