Unusual Collation "Compatibility_51_409_30001"


  • Hi

    We are preparing a database migration from SQL 2008 to SQL 2014 and noticed that one of the databases we are wanting to migrate has an unusual collation in sys.databases - Collation "Compatibility_51_409_30001".

    When right clicking the database in SSMS and going to Properties>Options the collation in blank.

    We cannot find any information on this collation and it is not listed in "select * from fn_helpCollations()"

    Can anyone shed any light on this mystery collation? and what equivalent collation should be?



    • Edited by DigitalPhil Thursday, July 12, 2018 12:57 PM Clarity
    Thursday, July 12, 2018 11:05 AM

All replies