Problem

1. After an upgrade or database migration, when creating a page and clicking the Save button, the page is lost.
2. Another symptom might be that you're able to create a new page, but cannot edit and save existing pages.
3. The database in use is Microsoft SQL Server.

The following appears in the atlassian-confluence.log:

2012-05-01 19:53:49,934 ERROR [TP-Processor5] [sf.hibernate.util.JDBCExceptionReporter] logExceptions Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CS_AS" and "SQL_Latin1_General_CP850_BIN" in the equal to operation.
 -- referer: http://localhost:8080/pages/docreatepage.action | url: /pages/docreatepage.action | userName: admin | action: docreatepage

Diagnosis

Run the following query against your old database. If it returns any results, you must adjust the collation before upgrading to newer versions of Confluence.

SELECT object_name(object_id) as TableName, name as ColumnName, collation_name
FROM sys.columns
WHERE collation_name <> 'SQL_Latin1_General_CP1_CS_AS'
AND object_name(object_id) NOT LIKE 'sys%'
AND object_name(object_id) NOT LIKE 'queue%'
AND object_name(object_id) NOT LIKE 'file%'
AND object_name(object_id) NOT LIKE 'spt%'
AND object_name(object_id) NOT LIKE 'MSrep%'

Cause

This issue is caused by a conflict between the collation of some table columns.

Resolution

There are several solutions:

1. Follow the steps on the "How to fix the collation of a MSSQL Confluence Database"
2. Export an xml backup and import it into a new instance of the same version of Confluence, which has the correct collation settings as described in this article. This solution may not work for larger instances.
3. Use the Collation Changer Tool. Note that this is a third party tool and not supported by Atlassian. Use at your own risk.
4. Your DB admin may be able to fix your database using a data migration tool.
5. Contact an Atlassian Expert who can give you hands on assistance.