[RRC] Collation settings on SQL Server
Accepted answer
Hello
I researched this once before for another forum post and this other post was the best I could find as to
why we require this setting: https://jazz.net/forum/questions/15200/changing-collation-on-users-db-during-sql-db-setup
It has to do with a requirement for case sensitivity.
I also found this workitem https://jazz.net/jazz/web/projects/Jazz%20Foundation#action=com.ibm.team.workitem.viewWorkItem&id=119996
SQL_Latin1_General_CP437_CS_AS is not mandatory, it just has to be one of the series of CS_AS collations, according to the development input in the above workitem. I think based on the naming convention, your customer has a setting that is case insensitive so that would not work for the CLM databases.
This is how the help topic used to read in v3r0: http://pic.dhe.ibm.com/infocenter/clmhelp/v3r0/topic/com.ibm.jazz.install.doc/topics/t_s_server_installation_setup_sql.html
and it was changed due to this workitem: https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=189132
I researched this once before for another forum post and this other post was the best I could find as to
why we require this setting: https://jazz.net/forum/questions/15200/changing-collation-on-users-db-during-sql-db-setup
It has to do with a requirement for case sensitivity.
I also found this workitem https://jazz.net/jazz/web/projects/Jazz%20Foundation#action=com.ibm.team.workitem.viewWorkItem&id=119996
SQL_Latin1_General_CP437_CS_AS is not mandatory, it just has to be one of the series of CS_AS collations, according to the development input in the above workitem. I think based on the naming convention, your customer has a setting that is case insensitive so that would not work for the CLM databases.
This is how the help topic used to read in v3r0: http://pic.dhe.ibm.com/infocenter/clmhelp/v3r0/topic/com.ibm.jazz.install.doc/topics/t_s_server_installation_setup_sql.html
and it was changed due to this workitem: https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=189132