I need to fetch both “red” and “RED”. For example: I need to use both upper and lower in same statement. How can I do this? Answer You could use case insensitive parameter at session ‘NLS_SORT=BINARY_CI’. There are two parameters at session level: NLS_COMP NLS_SORT Let’s see a demo: Normal scenario: Case insensitive approach: One more example: To improve the
Tag: case-insensitive
How do I get Django to run a case-insensitive query against my MySql 5.7 db?
I’m using Django 2.0 and Python 3.7. I have this model and manager for attempting to find my model by a name, case-insentively. The backing database is MySql 5.7. Unfortunately, when the query actually gets created, it doesn’t appear Django is doing anything to account for case-insensitivity. This is an example query that results … What changes do I need
Case insensitive searching in Oracle
The default behaviour of LIKE and the other comparison operators, = etc is case-sensitive. Is it possible make them case-insensitive? Answer Since 10gR2, Oracle allows to fine-tune the behaviour of string comparisons by setting the NLS_COMP and NLS_SORT session parameters: You can also create case insensitive indexes: This information was taken from Oracle case insensitive searches. The article mentions REGEXP_LIKE