[RRC] Collation settings on SQL Server
Hi
RRC v4.0.3 setup on SQLServer requires a collation setting of SQL_Latin1_General_CP437_CS_AS. My customer uses a default setting of Latin1_General_CI_AS. What are the implications of not having the correct settings? thanks anthony |
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 Anthony Kesterton selected this answer as the correct answer
Comments Thanks Rosa!
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.