Inconsistent search results.

Inconsistent search results.

Has this been raised before?

I have a database which defines a service, the service name is free hand entry by user.

Another user at a later date searches for services based on availability by time and location. I search the database and provide a list of services by name loaded into a drop-down list. The user selects the service by name,  I collect that and search the database to recover the record appropriate to the selection.

This sometimes does not work. It does not work because of an inconsistency in zoho search. When reading records from the database it ignores any trailing spaces. So the text "THIS IS A SERVICE" is recovered.

However when searching again from the database it is sensitive to trailing spaces so "THIS IS A SERVICE " is not found, despite being read earlier.