Case sensitivity

[Dev Kumkar <devdas.kumkar@xxxxxxxxx>]

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...