Index: openacs-4/packages/forums/lib/search/search-chunk-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/lib/search/search-chunk-postgresql.xql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/forums/lib/search/search-chunk-postgresql.xql	17 Dec 2003 15:45:30 -0000	1.1
+++ openacs-4/packages/forums/lib/search/search-chunk-postgresql.xql	7 Aug 2017 23:48:11 -0000	1.2
@@ -14,8 +14,8 @@
             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 || ' ' || forums_messages.content || ' ' || person__name(forums_messages.user_id))
-                       like '%' || upper(:search_text) || '%'
+            and    forums_messages.subject || ' ' || forums_messages.content || ' ' || person__name(forums_messages.user_id)
+                       ilike :search_pattern
             order  by forums_messages.posting_date desc
         </querytext>
     </fullquery>
@@ -32,8 +32,8 @@
             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 || ' ' || forums_messages.content || ' ' || person__name(forums_messages.user_id))
-                       like '%' || upper(:search_text) || '%'
+            and    forums_messages.subject || ' ' || forums_messages.content || ' ' || person__name(forums_messages.user_id)
+                       ilike :search_pattern
             order  by forums_messages.posting_date desc
         </querytext>
     </fullquery>