How to set IDENTIFIER_CASE to SENSITIVE

• Gordon Shannon

  SSC Rookie

  Points: 32

  More actions

  May 11, 2005 at 2:47 pm

  #152406

  It seems that there is only one setting to control case-senstivity in a database. If I set the database collation to, e.g., Latin1_General_CS_AI, I get case sensitive collation AND case sensitive identifiers. But if I set collation to Latin1_General_CI_AI, I get the opposite -- case insensitive collation AND case insensitive identifiers.

  Personally, I prefer case sensitive identifiers, but this causes problems when using 3rd-party sql that uses mixed (case-insensitive). So what I am looking for is a way to set identifier case-sensitivity independently of the collation setting, so I can have case sensitive collation and case insensitive identifiers.

  Any ideas?

  Thanks!

  Gordon

• May 16, 2005 at 8:00 am

  This was removed by the editor as SPAM

• Steven.

  SSCrazy Eights

  Points: 9806

  More actions

  May 17, 2005 at 3:55 am

  #559196

  Collation can be set at field level on the table.

  Steven