Equivalent Term Already Exists

Error Message in Case of an Equivalent Term

Error message "Equivalent Term Already Exists" shows if an entry is added to a thesaurus which already holds an entry with an equivalent name. Whether two names are equivalent or not is decided by the database. It is common for databases to consider very similar terms as equivalent to optimize search results. This behaviour is called "collation":

• MySQL (opens new window)
• SQLServer (opens new window)

For example, databases are often configured case-insensitive. A case-insensitive database will find the term "Bike" even though the search term was "bike" or "BIKE". If a case-insensitive database is used for the 4ALLPORTAL, the 4App Thesaurus cannot hold entries which differ only in their capitalization. There is no need to do so. It is sufficient to define one of those entries and add all the synonyms and misspellings to this one.

In order to find out which collation is set in your database, use one of the following statements:

MySQL:

SELECT * FROM INFORMATION_SCHEMA.SCHEMATA

SQLServer:

SELECT CONVERT (varchar(256), SERVERPROPERTY('collation'));