Some DBMSs allow case sensitive column and table names as well as names with special characters such as an Oracle column named Amount Budgeted$. Therefore, special consideration should be used when ...

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.