Stack Overflow
Stack Overflow

Questions tagged [freetext]

FREETEXT is an SQL text-search predicate that uses stemming (e.g. -ing, -ly) and a thesaurus to search for the given string.

FREETEXT is a predicate used to search columns containing character-based data types for values that match the MEANING and not the exact wording of the words in the search condition. When FREETEXT is used, the full-text query engine internally performs the following actions on the freetext_string, assigns each term a weight, and then finds the matches.

109 questions
1
vote
1 answer

C# Console.Read, prevent use of special characters by user

Is there a way to limit free-text when using Console.ReadLine(); to prevent the use of special characters such as / , % ,$ , #. Currently I allow all characters and then use a .Replace("[special character","") to get rid of any. Here is an example…
Joshua Jaynes
  • 61
  • 3
1
vote
0 answers

JIRA/JQL exclude by specific comment?

I can easily find issues with a specific comment which might end up as 6 out of 30 items. But I want to exclude each item containing a specific text string to get the remaining items. (I'm NOT admin in our system, just a regular user) Can…
Johan Grimm
  • 11
  • 4
1
vote
0 answers

EF Core 5: FreeText Failed to convert parameter value from a String to a Byte[] on a Full-Text indexed Byte[] column

I have the following entity with a property Content of type byte[]: public class Post { [Column(TypeName = "varbinary(max)")] [Required] public byte[] Content { get; set; } public string ContentType { get; set; } } and the content type…
Ali Kleit
  • 3,069
  • 2
  • 23
  • 39
1
vote
1 answer

Freetext search multi-columns in c # (Linq)

Is there the possibility by using EF.Functions.FreeText to search on multiple columns? The function accepts as input parameters: the column in which to perform the search and the string to search for, but in the documentation I cannot find anything…
Riccardo Pezzolati
  • 357
  • 1
  • 4
  • 15
1
vote
1 answer

SQL Server Freetext Varbinary returns nothing and Conversion VARBINARY -> VARCHAR Not working

Hey I've a few issues with my solution and I can't figure it out Below is my creation table CREATE TABLE FreeTextSearch ( [ID] BIGINT NOT NULL IDENTITY(1,1), [Content] VARBINARY(MAX) NOT NULL, [SubjectClass] VARCHAR(30) NOT NULL, …
VoidEssy
  • 23
  • 7
1
vote
0 answers

Using Oracle Text Multicolumn Datastore Can I Weight The Columns Differently

A business requirement dictates that for implementing a full text search solution, that certain fields being searched have more weight than others. Although I have found that you can add weight to the search terms themselves, I'm not sure it…
Eric Huddle
  • 33
  • 5
1
vote
1 answer

Setting transparent color as strokeColor in Acrobat JS API results in black border

my problem is that when I try to set transparent as strokeColor for FreeText annotation when adding one the resulting annotations has black border. I try to code it like this: this.addAnnot({ type: "FreeText", contents: "TEST", strokeColor:…
eLGi
  • 80
  • 2
  • 10
1
vote
0 answers

I have question about an example code in Microsoft Docs "FREETEXT (Transact SQL)"

I want to use Freetext statement for search a phrase in SQL Server 2016 not separated words base on this sample code in Microsoft Docs.(https://learn.microsoft.com/en-us/sql/t-sql/queries/freetext-transact-sql?view=sql-server-2017) USE…
Hamid Reza Moein
  • 11
  • 2
1
vote
2 answers

EF Core freetext with child entity

EF Core 2.1 has added support for FREETEXT, as also discussed in How to use FreeText in EF core 2.1. I have a different problem, however, using EF Core 2.2: Does EF Core's FREETEXT support child entities? public class Customer { public Name Name…
Rogier van het Schip
  • 861
  • 7
  • 23
1
vote
1 answer

SQL Server Full-Text search Empty catalog

I'm trying to get a full-text search running on SQL Server in Azure. My data is in a varbinary(max) with all columns containing data. The data is strings of html. The SearchableData column is computed and filled…
Herlin
  • 353
  • 1
  • 5
  • 12
1
vote
0 answers

Fuzzy Search Logic

I am working on a search function in my PHP webpage, whereby users can enter keywords to search for. Problem is I need a fuzzy search logic that can capture keywords of different permutations and positions, therefore I am using FULL TEXT INDEX and…
Angel Lim
  • 27
  • 1
  • 6
1
vote
3 answers

Using CONTAINS to find items IN a table

I'm trying to write a SP that will allow users to search on multiple name strings, but supports LIKE functionality. For example, the user's input might be a string 'Scorsese, Kaurismaki, Tarkovsky'. I use a split function to turn that string into…
Julian Drago
  • 719
  • 9
  • 23
1
vote
1 answer

Free text (natural language) query parsing with solr

I'm trying to build a query parsing algorithm for a local search site that can classify a free text search query (single input text box) into various type of possible searches possible on the site. For e.g. the user could type chinese restaurants…
Gunjan
  • 1,177
  • 2
  • 11
  • 22
1
vote
0 answers

SQL Fulltext index seems to ignore subscript/superscript numbers

I have a fulltext index on a binary field that stores superscript and subscript numbers. When searching the field, the same results are returned whether you add super/sub script numbers to your search or not. Some details on how this is…
Jean-Luc Chapotot
  • 11
  • 1
1
vote
1 answer

SQL Server full text search on column with alias

I am using full-text search, its working fine on a direct column of table but not on a derived/aliased column. SELECT ExpectationId ,ExpectationName ,( CASE WHEN ExpectationOrganization_OrganizationId IS NOT NULL …
Ali Shahzad
  • 5,163
  • 7
  • 36
  • 64
1 2
3
4 5 6 7 8