SQL Server - Collation Settings

In this article we will learn on how to change the collation settings at database level.

Use [Poland-Showroom-DB]

SELECT name, collation_name FROM sys.databases WHERE name = 'Poland-Showroom-DB';

SQL Syntax

-- make sure database in Single user mode

ALTER DATABASE [Poland-Showroom-DB] SET SINGLE_USER WITH ROLLBACK IMMEDIATE

-- change collation to Polish_CI_AS

ALTER DATABASE [Poland-Showroom-DB] COLLATE Polish_CI_AS;

-- allow database in operational mode

ALTER DATABASE [Poland-Showroom-DB] SET MULTI_USER

Here is the related article to cross verify the Windows and SQL Language Code Identifiers (LCID).

https://learn.microsoft.com/en-us/sql/relational-databases/collations/collation-and-unicode-support?view=sql-server-ver16

Best Regards

Amit Vaid