Hello,
Is there a way to set string comparisons to be case-insensitive globally? I
understand LOWER() can be used, but my codebase contains 27k lines of SQL
and many string comparisons. I would need to apply LOWER() to each string
literal in the code base. I'd also need to change all the ETL/import code
to apply LOWER() to each string value on import.
Current behavior:
SELECT 'ABC' = 'abc';
false
Time taken: 5.466 seconds, Fetched 1 row(s)
SELECT 'ABC' IN ('AbC', 'abc');
false
Time taken: 5.498 seconds, Fetched 1 row(s)
SELECT 'ABC' like 'Ab%'
false
Time taken: 5.439 seconds, Fetched 1 row(s)
Desired behavior would be true for all of the above with the proposed
case-insensitive flag set.
Thanks,
Patrick
