SQL Server Collation
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-14-2014 03:21 PM
3 REPLIES 3
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-16-2014 02:40 AM
Docs say default.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.
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.
