lib/data_tables.rb in data_tables-0.1.21 vs lib/data_tables.rb in data_tables-0.1.22

@@ -262,10 +262,10 @@
           define_method action.to_sym do
             condition_local = ''
             unless params[:sSearch].blank?
               sort_column_id = params[:iSortCol_0].to_i
               sort_column = columns[sort_column_id]
-              condstr = params[:sSearch].strip.gsub(/_/, '\\\\_').gsub(/%/, '\\\\%')
+              condstr = params[:sSearch].strip.gsub(/%/, '%%').gsub(/'/,"''")
 
               search_columns = options[:columns].map{|e| e.class == Symbol ? e : e[:attribute] }.compact
               condition_local = search_columns.map do |column_name|
                 " ((text(#{column_name}) ILIKE '%#{condstr}%')) "
               end.compact.join(" OR ")