AnsweredAssumed Answered

EPDM database collation

Question asked by Kris Jankiewicz on Mar 24, 2010
Latest reply on Mar 25, 2010 by Joy Garon

I recently ran into problems with mismatched server & database collation on a project not associated with EPDM whatsoever. After fixing the problem I decided to check my EPDM database server to see what collations have been chosen. I noticed that the SQL Server 2005 default collation is set to "SQL_Latin1_General_CP1_CI_AS" which is a compatible with previous versions of SQL Server (designated by the "SQL_" prefix). I verified all the system databases (master, model, msdb and tempdb) and they were all set to the same collation as the server default.

 

Then I checked the two EPDM databases and found that the ConisioMasterDb database was the same as the server default as well but our actual vault database was set to "Latin1_General_CI_AS_KS_WS". Our VAR used a pre-loaded database to kickstart our vault setup. Is this the proper collation for the vault databases?  If not, does anyone know if this could cause a problem? I only ask because we sometimes experience weird problems and poor database performance.

 

Thanks in advance to those that can shed some light on this matter.

 

-Kris

Outcomes