Index: openacs-4/packages/forums/lib/search/search-chunk-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/lib/search/search-chunk-oracle.xql,v
diff -u -r1.1 -r1.1.2.1
--- openacs-4/packages/forums/lib/search/search-chunk-oracle.xql	17 Dec 2003 15:45:30 -0000	1.1
+++ openacs-4/packages/forums/lib/search/search-chunk-oracle.xql	18 Apr 2004 19:19:15 -0000	1.1.2.1
@@ -14,7 +14,7 @@
             where  forums_messages.forum_id = forums_forums.forum_id
             and    forums_forums.package_id = :package_id
             and    forums_messages.state = 'approved'
-            and    upper(forums_messages.subject || ' ' || dbms_lob.substr(forums_messages.content) || ' ' || person.name(forums_messages.user_id))
+            and    upper(forums_messages.subject || ' ' || dbms_lob.substr(forums_messages.content,2500) || ' ' || person.name(forums_messages.user_id))
                        like '%' || upper(:search_text) || '%'
             order  by forums_messages.posting_date desc
         </querytext>
@@ -32,7 +32,7 @@
             and    forums_forums.package_id = :package_id
             and    forums_messages.forum_id = forums_forums.forum_id
             and    forums_messages.state = 'approved'
-            and    upper(forums_messages.subject || ' ' || dbms_lob.substr(forums_messages.content) || ' ' || person.name(forums_messages.user_id))
+            and    upper(forums_messages.subject || ' ' || dbms_lob.substr(forums_messages.content,3500) || ' ' || person.name(forums_messages.user_id))
                        like '%' || upper(:search_text) || '%'
             order  by forums_messages.posting_date desc
         </querytext>