Collation describes the code page, case sensitivity, accent sensitivity, and language or alphabet in use. This SQL Server tip illustrates how you can force the use of any specific collation.

Column names can be case-sensitive also. Some DBMSs allow case sensitive column ... are used with SAS/ACCESS and the SQL Procedure Pass-Through Facility. See your DBMS chapter for more information ...