Collation question for sql 2005

• fizzleme

  SSCertifiable

  Points: 6906

  More actions

  May 24, 2010 at 12:50 pm

  #221897

  I have a sql 2005 standard server with 2 databases.

  Database A uses collation SQL-latin1-general-CP1-CI-AS

  Database b uses Latin1-general-bin with a binary sort order.

  I need to confirm database A is case insensitive.

  How can I do this? Sorry for my ignorance.

  When the snows fall and the white winds blow,The lone wolf dies but the pack survives.

  Once you've accepted your flaws, no one can use them against you.

• David Webb-CDS

  SSCoach

  Points: 17398

  More actions

  May 24, 2010 at 1:18 pm

  #1171730

  The -CI- in the name means case-insensitive. You can check with:

  declare @v1 char(1)

  declare @v2 char(1)

  set @v1 = 'a'

  set @v2 = 'A'

  if @v1 = @v2

  print 'case insensitive'

  ---

  And then again, I might be wrong ...
  David Webb