Tag: Oracle like case insensitive

We need to set the NLS_COMP parameter to LINGUISTIC, which will tell the database to use NLS_SORT for string comparisons. Then we will set NLS_SORT to a case insensitive setting, like BINARY_CI .

Most SQL Server installations are installed with the default collation which is case insensitive. This means that SQL Server ignores the case of the characters and treats the string ‘1 Summer Way’ equal to the string ‘1 summer way’.

We need to set the NLS_COMP parameter to LINGUISTIC, which will tell the database to use NLS_SORT for string comparisons. Then we will set NLS_SORT to a case insensitive setting, like BINARY_CI .

The LIKE statement is used for searching records with partial strings in MySQL. By default the query with LIKE matches case-insensitive recores . Means query will match both records in lowercase or uppercase. For example, Search all records un colors table where name is start with “Gr”.