Anyone upgraded to confluence 5 with new database schema?

[Alex Mags]

Hi
Confluence database schema changes to case sensitive and unicode strings. The upgrade process fails when adding user_mapping table (assumes all user references are unicode nvarchar). Anyone have a process to upgrade from 4 to 5? Using MS SQL.

[FelipeA]

Hi Alex,

First thing is to make sure you're running Confluence with the right collation: SQL_Latin1_General_CP1_CS_AS. If you don't, then please follow this procedure: https://confluence.atlassian.com/display/CONFKB/Collation+Conflict+When+Creating+PagesNow about the data types, nvarchar, ntext and nchar, please follow this other procedure: https://confluence.atlassian.com/display/CONFKB/Confluence+upgrade+fails+due+to+SQL+Server+could+not+complete+schema+update

Best regards,

Felipe Alencastro