[rt-users] Oracle Issue

Jesse Vincent jesse at bestpractical.com
Tue Apr 1 20:04:52 EST 2003


This discussion is really apropriate on rt-devel, not rt-users. 
We actually _had_ this discussion there a couple weeks ago. The archives
will be quite enlightening.


On Tue, Apr 01, 2003 at 04:56:18PM -0800, John Gedeon wrote:
> 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."
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 
> Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

-- 
http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.



More information about the rt-users mailing list