Oracle Issue

RT Users
1

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.”

2

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@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

Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.

3

I will look into the archives and the long data type thanks :slight_smile:

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.”