Case Sensitivity for MS SQL database
The TeamCity documentation recommend Case Sensitive MS SQL database (http://confluence.jetbrains.com/display/TCD7/Setting+up+an+External+Database#SettingupanExternalDatabase-MySQL). All versions documentations above TeamCity 5.x seems to have this and 4.x and below don’t mention it.
However, there are several support queries where the recommended collation is Case Insensitive:
http://devnet.jetbrains.com/message/5457121#5457121
http://devnet.jetbrains.com/message/5237390#5237390
http://devnet.jetbrains.com/message/5237237#5237237
Which way do we go ?
Can you please verify if SQL_Latin1_General_CP1_CI_AS is usable.
Please sign in to leave a comment.
What version of TeamCity do you use?
We currently use 7.1.4.
I would also like to know if it would be the same for 8.x
Hello Jayesh,
TeamCity 6.x-8.x supports both case-seinsitive and case-insensitive databases. However, if your build farm contains unix agents, with case-INsensitive database you might experience some strange exceptions from TC. So, I'd recommend using case-sensitive databases only as a TemaCity backend.
As of the mentioned issues, they all are not actual for TeamCity since version 6.