Forum Discussion

Zequion1's avatar
Zequion1
Copper Contributor
Sep 22, 2024

Select greater than 4000 characters.

I have been working for years on a semantic search engine in WPF and in Asp.Net with C# and Sql Server 2022 and I need to be able to search for synonyms and inflections of the words in the phrase that the user enters.

 

I have encountered the problem that the parameter “contains_search_condition” of the Contains or ContainsTable command is limited to 4000 characters.

 

Just by searching for the synonyms and inflections of a word, this limit can be exceeded. It is not solved even if the words are entered into a Varchar(max) variable and passed to the parameter.

 

I can't use the synonyms system that T-Sql includes for "Full Text" because it is too simple and has multiple errors and shortcomings and I think it was abandoned in 2008 because they never talked about it again.

 

Several years ago I reported this problem and other important problems that I have found in T-Sql to Microsoft Spain in writing, who reported it to Microsoft USA. They told me that "they were going to work on these problems."

 

I have not heard anything again and I need a solution, because I am stuck on this problem.

 

I cannot write the query text because it says "violation of the code of conduct" and deletes the post.

I have left the SQL code at: https://mega.nz/file/9xxThBDK#dBWn5Tdy0IvtdCd3qtpq9Mk8C-29pO87TogdvAB2zVI

 

This is a current query:

I have tried to split as Rodger Kong advised me but the problem persists.

 

 

 

  • rodgerkong's avatar
    rodgerkong
    Iron Contributor
    I think you misunderstood my idea...
    Let's do some discussion privately.
    • Zequion1's avatar
      Zequion1
      Copper Contributor

      I can't send more than 1 message. If you can, create the code with the synonyms I gave you and run it.

       

      • rodgerkong's avatar
        rodgerkong
        Iron Contributor
        Send you a email, I can't access the site you post the code. pls check your yahoo mailbox

Resources