MSSQLSERVER_12329

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Details

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')