Search bar that isn't capital sensitive

Need help
10

Do you have a “thing” that is a tupple of (“lower case string”, “unique_id” , “object type”), or do you add a “lower case string” field to the thing? What if you have many fields to search for? Do you create several lowercase fields? Triggers on data tables are to be used, in my view, as a last resource… On the long run, it will bite you…