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.
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. Read More
