SQL SERVER - II||How to change the column as case sensitive?

1. CI = Case Insensitive (default) 2. CS = Case Sensitive 3. AI = Accent Insensitive 4. AS = Accent Sensitive