SQL_Latin1_General_CP1_CI_AS collation

• Ionut Hrubaru

  SSC Veteran

  Points: 276

  More actions

  June 2, 2010 at 6:29 am

  #222157

  I am using SQL_Latin1_General_CP1_CI_AS collation for my servers. It is a case insensitive collation, meaning that A = a, Z = z and so on.

  All works fine except for a set of characters ž and Ž, Ÿ and ÿ, Š and š, Œ and œ.

  For example:

  --Ž is the uppercase for ž:

  select case when UPPER('ž') = 'Ž' then 1 else 0 end --returns 1

  --Ž <> ž

  select case when 'ž' = 'Ž' then 1 else 0 end --returns 0

  Any explanation why the normal behavior is overridden? Is there somewhere a list of characters for which the case insensitive rule does not apply (for SQL_Latin1_General_CP1_CI_AS collation).

  Thanks

• NazerMohamed

  Mr or Mrs. 500

  Points: 502

  More actions

  June 2, 2010 at 8:17 am

  #1175319

  I am using Latin1_General_CI_AS

  select case when 'ž' = 'Ž' then 1 else 0 end ---- returns 1

  NM

• Ionut Hrubaru

  SSC Veteran

  Points: 276

  More actions

  June 2, 2010 at 1:38 pm

  #1175544

  Good to know.

  However, I am still stuck with this