locked
What is Right Requirements of Database Collation RRS feed

  • Question

  • Hello,

    Following cases, Configuration wizard(step 3) failed after install of Project Server 2010.
     case 1 : SQL Server installed with Japanese Collation.
     case 2 : SQL Server installed with Japanese Collation and MODEL DB set Latin1_General_CI_AS_KS_WS.
    I think that I can install Project Server 2007 like case 1 and case 2...(I might make a mistake.)
    I hope that Latin1 collation use minimum requirements and other DBs use local Language, like Japanese.

    Following case, Configuration wizard success and I can create PWA site.
     case 3 : SQL Server installed with Latin1_General_CI_AS_KS_WS.

    Technet library say "Use SQL_Latin1_General_CP1_CI_AS".
     http://technet.microsoft.com/en-us/library/ee662108(office.14).aspx
     http://technet.microsoft.com/ja-jp/library/ee662108(office.14).aspx

    But I can install with windows collation, Latin1_General_CI_AS_KS_WS.

    Do I really use SQL Collation, SQL_Latin1_General_CP1_CI_AS ?
    What collation can I use ?
    Why change to impossible case 1 / 2 ?

    # Sorry, my English ability is very limited.

    Regards,

    MCITP(Database Developer/Database Administrator)
    Wednesday, December 9, 2009 3:43 AM

Answers

  • Nagino:
     
    I believe that the absolute requirement is that the collation you select must be:
    Case-insensitive (CI)
    Accent-sensitive (AS)
    Kana-sensitive
    Width-sensitive
     

    --
    Gary L Chefetz, MVP, MCT, MCITP
    msProjectExperts http://www.msprojectexperts.com
    FAQs and Reference http://www.projectserverexperts.com
    BLOG: http://projectserverhelp.com

    Gary Chefetz, MCITP, MCP, MVP MSProjectExperts http://www.msprojectexperts.com FAQs: http://www.projectserverexperts.com BLOG: http://www.projectserverhelp.com
    Wednesday, December 9, 2009 3:25 PM
  • Hi Nagino - Gary is correct, our requirement is unchanged from Project Server 2007 and is:

    SQL Server and database collation

    The SQL Server collation must be configured as case-insensitive. The SQL Server database collation must be configured as case-insensitive, accent-sensitive, Kana-sensitive, and width-sensitive. This configuration ensures file name uniqueness consistent with the Windows operating system. For more information about collations, see "Selecting a SQL Collation" or "Collation Settings in Setup" in SQL Server Books Online.

    (From: http://technet.microsoft.com/en-us/library/cc197479.aspx#section5)

    Friday, December 11, 2009 12:41 AM

All replies

  • Nagino:
     
    I believe that the absolute requirement is that the collation you select must be:
    Case-insensitive (CI)
    Accent-sensitive (AS)
    Kana-sensitive
    Width-sensitive
     

    --
    Gary L Chefetz, MVP, MCT, MCITP
    msProjectExperts http://www.msprojectexperts.com
    FAQs and Reference http://www.projectserverexperts.com
    BLOG: http://projectserverhelp.com

    Gary Chefetz, MCITP, MCP, MVP MSProjectExperts http://www.msprojectexperts.com FAQs: http://www.projectserverexperts.com BLOG: http://www.projectserverhelp.com
    Wednesday, December 9, 2009 3:25 PM
  • Hi Gary Chefetz,

    Thank you for your reply.

    Maybe important of collation is selection of sensitive/insensitive.

    So I would like to check if I will have time.
     Can I use Japanese_100_XJIS_CI_AS_KS_WS ?
     Can I use Latin1_General_100_CI_AS_KS_WS ?
     Can I Use other collations.

    If anyone have more infomations, please reply.

    Thanks,


    MCITP(Database Developer/Database Administrator)
    Thursday, December 10, 2009 1:56 AM
  • Hi Nagino - Gary is correct, our requirement is unchanged from Project Server 2007 and is:

    SQL Server and database collation

    The SQL Server collation must be configured as case-insensitive. The SQL Server database collation must be configured as case-insensitive, accent-sensitive, Kana-sensitive, and width-sensitive. This configuration ensures file name uniqueness consistent with the Windows operating system. For more information about collations, see "Selecting a SQL Collation" or "Collation Settings in Setup" in SQL Server Books Online.

    (From: http://technet.microsoft.com/en-us/library/cc197479.aspx#section5)

    Friday, December 11, 2009 12:41 AM