public override string GetFulltextSearchExpr(string expr, string substring, FulltextSearchParams pars) { substring = substring.Replace("*", "[*]").Replace("?", "[?]").Replace("_", "[_]").Replace("*", "[*]"); return(String.Format("({0} LIKE {1})", expr, this.GetSqlLiteral(pars.LikePrefix + substring + pars.LikePostfix))); }
public override string GetFulltextSearchExpr(string expr, string substring, FulltextSearchParams pars) { substring = substring.Replace("@", "@@").Replace("%", "@%").Replace("_", "@_"); return(String.Format("(lower({0} || '') LIKE lower({1}) ESCAPE '@')", expr, this.GetSqlLiteral(pars.LikePrefix + substring + pars.LikePostfix))); }