Select greater than 4000 characters.

Copper Contributor

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:

Sql.jpg

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

Zequion1_0-1726967555252.png

 

 

 

5 Replies
I think you misunderstood my idea...
Let's do some discussion privately.

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

Zequion1_0-1726972829848.png

 

Send you a email, I can't access the site you post the code. pls check your yahoo mailbox
What is your email?
Ok. It was in spam. I'll send you an email now.