Configuring Case-Insensitivity for the Offline Database

You can configure the offline database to accept case-insensitive values for string comparisons.

Context

By default, the offline database is case-sensitive. For example, when executing a case-sensitive comparison operation, an upper-case letter "S" and a lower-case letter "s" are treated as unique values returning no match. When case-insensitivity is enabled, "S" and "s" are treated as equal values returning a match.

Procedure

To enable case-insensitivity, do one of the following:

Edit the application's config.ini file, and set the case_sensitive_offline_db= property value to no. For example,
```
case_sensitive_offline_db=no
```

Use the substringof filter with the tolower() function in a URL. For example,

http://services.odata.org/V2/OData/OData.svc/Products?$format=json&$filter=substringof(tolower(Name) eq 'bread')

Instead of

http://services.odata.org/V2/OData/OData.svc/Products?$format=json&$filter=Name eq 'bread'