SQL case-sensitive issues

Insert,select  are not case-sensitive for database keywords.

But  the table name, field name.  



SQL Server is a database setting that determines whether a table name field name is case-sensitive
Oracle uses  double quotes to determine
MySQL is dependent on configuration and operating system to decide (Windows does not differentiate, Linux differentiates)

Case-sensitive processing in SQL Server.
Http://hi.baidu.com/wangzhiqing999/blog/item/2c41440392671cd87a894746.html

Case-sensitive issues for strings

In SQL SERVER, if the direct select * FROM tablename where column1 = ' XXXX ' is case-insensitive, how do you make SQL case-sensitive?

Collate explained that it is the choice of sorting (too long, not attentively), but can also be used in query case sensitivity, such as:
SELECT * FROM tablename where Column1 collate chinese_prc_cs_as= ' Xxxx '
SELECT * from S where SN collate chinese_prc_cs_as like ' l% '

The CI specifies case-insensitive, and the CS-specified sensitivity is casing-sensitive.
AI Specifies accent-insensitive, as specifies accent sensitivity.
The omitted specifies case-insensitive, and the WS-designation is casing-sensitive.

SQL case-sensitive issues