Sample Header Ad - 728x90

Different collation between master database and application database

4 votes
1 answer
1046 views
I just installed SQL Server 2019. Unfortunately I didn't notice the collation while installing. Following are the collations: SELECT name, collation_name FROM sys.databases | name | collation_name | |--------------------|--------------------------------| | master | Latin1_General_CI_AS | | tempdb | Latin1_General_CI_AS | | model | Latin1_General_CI_AS | | msdb | Latin1_General_CI_AS | | ReportServer | Latin1_General_100_CI_AS_KS_WS | | ReportServerTempDB | Latin1_General_100_CI_AS_KS_WS | | ApplicationDB | SQL_Latin1_General_CP1_CI_AS | use ApplicationDB GO SELECT SERVERPROPERTY(N'Collation') > SQL_Latin1_General_CP1_CI_AS The application recommends that the database to be SQL_Latin1_General_CP1_CI_AS, but they're unsure about the system databases as they're not database experts. Will there be any consequences. We would be running SSRS reports to pull data from the application database. Will this be an issue? I'm confused
Asked by Master_Roshy
May 12, 2022, 05:46 PM
Last activity: Aug 5, 2025, 07:09 AM