•The text changes are not indexed instantaneously. You may notice a several seconds of delay before a new entry becomes retrievable by full-text search.

•It is generally not possible to find articles by hyphenated words, as they are saved in the editorial database as hyphenated. Thus, searching for placeholder while it appears only as place-holder in a text, won't find anything.

•Neither Exalead nor SQL full text search offer case-sensitive mode. Thus, searching for term or TERM or Term will return either.

•It is not possible to search for stop (noise) words. The message "Cannot use noise words in searches! Please redo the query" appears.

•You cannot search for a term not containing a specific character.

•In order to search for non alphanumeric characters in Solr, you need to enter the list of such characters in the GlobalConfig.

Searching for numbers as full-text in SQL

In Microsoft SQL server full-text searches, single numbers are stop words, and therefore cannot be retrieved correctly. If you search for "1", nothing is found. If you search for "Title 1", the search will find texts containing "Title 1" but also "Title 2", "Title 3" and so on, as the search criteria is indeed shortened to "Title" and the single number is ignored. This limitation applies only to single numbers, as 01 or 21 are found correctly, and also "Title 01" or "100".

Searching for numbers as full-text in Exalead

It works as you would expect.

Searching for tags

It may be supported in SQL FTS, but it is not supported in Exalead.