Difference between Windows Collation and SQL Collation?

guidf0147
guidf0147 Member Posts: 4
edited 2010-03-08 in NAV/Navision Classic Client
Hi,everyone
what is the difference between Windows Collation and SQL Collation?

Comments

  • rdebath
    rdebath Member Posts: 383
    AIUI the sort order is different and possibly also the exact semantics of UPPERCASE and LOWERCASE.

    Though this may only apply to SQL unicode strings.

    I normally use the Windows Collation.
    Robert de Bath
    TVision Technology Ltd
  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    There is a lot of overlap in the collations for windows and SQL.

    When Microsoft SQL Server started years ago they had their just own collations. Later they decided (wisely) to merge with Windows collations.

    Today, the SQL Collations still exist and are supported for backwards compatibility.

    Best practive is for new systems to start with Windows collations.
    Marije Brummel | Freelance Business Central Specialist
  • David_Singleton
    David_Singleton Member Posts: 5,479
    Mark Brummel wrote:
    There is a lot of overlap in the collations for windows and SQL.

    When Microsoft SQL Server started years ago they had their just own collations. Later they decided (wisely) to merge with Windows collations.

    Today, the SQL Collations still exist and are supported for backwards compatibility.

    Best practive is for new systems to start with Windows collations.


    :thumbsup:

    Thanks for that. I never use them, but was always curious where SQL Collations came from.
    David Singleton

Categories