MSSQLSERVER_12329

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance SQL database in Microsoft Fabric

Details

Attribute	Value
Product Name	SQL Server
Event ID	12329
Event Source	MSSQLSERVER
Component	SQLEngine
Symbolic Name	HK_UNSUPPORTED_NON_LATIN_CODEPAGE
Message Text	The data types char(n) and varchar(n) using a collation that has a code page other than 1252 are not supported with construct.

Explanation

Do not use the data types char(n) and varchar(n) using a collation that has a code page other than 1252.

User Action

One unexpected situation that can generate this error is:

BEGIN ATOMIC WITH (TRANSACTION ISOLATION LEVEL = SNAPSHOT, LANGUAGE = 'us_english')  

Use this instead:

BEGIN ATOMIC WITH (TRANSACTION ISOLATION LEVEL = SNAPSHOT, LANGUAGE = N'us_english')