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