Queries are limited to 4000 characters.

Question

I am working on a semantic search engine 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.

Several years ago I reported this problem and others that I have found in writing to Microsoft Spain, 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 can't write the text of the query because it says "violation of the code of conduct" and deletes the post.

Answer 1

Hi @zequion

Have you tried split the search conditions into multiple smaller conditions that fit with the 4000-character limit?

Best regards,

Cosmog

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".