Hyland Community
Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

SQL Server Collation

psycdoc
Champ in-the-making
Champ in-the-making

‎10-14-2014 03:21 PM

Can anyone tell me what the collation setting should be on SQL Server 2012.
Labels:
0 Kudos
3 REPLIES 3

mrogers
Star Contributor
Star Contributor

‎10-16-2014 02:40 AM

Docs say default.
0 Kudos

psycdoc
Champ in-the-making
Champ in-the-making
In response to mrogers

‎10-17-2014 03:57 PM

I changed my default collation when I installed my SQL server. I had to do this for another application that has a database on the server. So now I need to know what Alfresco prefers at its collation. 
0 Kudos

psycdoc
Champ in-the-making
Champ in-the-making

‎10-17-2014 04:04 PM

I am receiving this error:

13:34:52,206 ERROR [org.alfresco.util.DatabaseMetaDataHelper] [localhost-startStop-1] Unable to determine current schema.
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CS_AS" and "SQL_Latin1_General_CP1_CI_AS" in the INTERSECT operation.
0 Kudos
Getting started

Tags

Find what you came for

We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.

Copyright © 2025 Khoros, LLC