Most SQL installations have default collation. i.e case insensitive or SQL_Latin1_General_CP1_CI_AS in SQL Server glossary.

It can be changed at server, DB or column levels.

How to check current collation?
SELECT SERVERPROPERTY (‘Collation’)