SQL case insensitive

By default, searches are case-insensitive . You can make your search case-sensitive by using the case filter. For example, the following search returns only results that match the term HelloWorld . It excludes results where the case doesn’t match, such as helloWorld or helloworld .

This means that a search for a term matches other occurrences of that term, regardless of their case in the original document, and regardless of the case in which the search term is written . For example, a search for Dog matches documents that originally contained terms such as dog, DOG, Dog, or DoG.

This means that a search for a term matches other occurrences of that term, regardless of their case in the original document, and regardless of the case in which the search term is written . For example, a search for Dog matches documents that originally contained terms such as dog, DOG, Dog, or DoG.