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.

3 comments
Comment actions Permalink

What version of TeamCity do you use?


0
Comment actions Permalink

We currently use 7.1.4.

I would also like to know if it would be the same for 8.x

0
Comment actions Permalink

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.

0

Please sign in to leave a comment.