SQL Server Performance

SQL Server 2008 collation

Discussion in 'SQL Server 2008 Questions [Archive Only - Closed]' started by pldenomme, Jan 21, 2009.

  1. pldenomme New Member

    Does anybody knows what's de difference between the old collation Latin1_General and the new Latin1_General_100 introduced in SQL Server 2008
  2. moh_hassan20 New Member

    There are different family of Latin1_General and the new Latin1_General_100
    the new family in sql 2008 have _100 suffix and have different sort orders than other collations in the same language and may map to a different code page.
    run the following script to know details:
    SELECT * , COLLATIONPROPERTY(name, 'version') version
    ,COLLATIONPROPERTY(name, 'LCID') lcid
    ,COLLATIONPROPERTY(name, 'ComparisonStyle') ComparisonStyle
    FROM fn_helpcollations()
    where name like 'Latin%'
    order by name

  3. satya Moderator

Share This Page