How to create case insensitive database? I know about CITEXT data type, but what am looking for is if there any parameter at database level which just makes the database case insensitive.
I mean both values 'ABC' and 'abc' are treated same for inserts and also all the comparisons by default are case insensitive. Was not able to find anything concrete forums, hope I didn't overlook anything here. Regards...