To make an adaplet operate in the case insensitive mode, add the
following line to the adaplet mapping file:
item casesensitive false
Without this line, adaplets will continue to behave in a case-sensitive
fashion. Adding this line to an adaplet mapping file causes
3DSpace
to generate SQL against the foreign database that wraps all arguments inside of
an 'upper()' expression. This alone does not assure the foreign database was
designed and indexed in a way that makes case-insensitive operations viable.
The foreign database might need its own configuration to run in a case
insensitive manner.
If the adaplet has case-sensitivity turned on and is in extend or
migrate mode, then types must use mapped IDs. For more information, see the
Adaplet Programming Guide.