FIX: Replication isn't enabled when database collation uses '_SC' collation extension in SQL Server 2016 and 2017

Platí pro: SQL Server 2017 Developer on WindowsSQL Server 2017 Enterprise on WindowsSQL Server 2017 Enterprise Core on Windows

Symptoms


Databases that use collations with supplementary characters (_SC) cannot be enabled for SQL Server Replication in Microsoft SQL Server 2016 and 2017. This issue occurs because some system tables and stored procedures that are created for replication use the legacy text, ntext and image data type which does not support supplementary characters.

This change updates all the associated system tables, stored procedures and system views so that replication can be enabled when the '_SC' collation extension is used.

Resolution


This issue is fixed in the following cumulative update and service pack for SQL Server:

       Cumulative update 5 for SQL Server 2017

Service pack information for SQL Server 2016

This issue is fixed in the following service pack for SQL Server: 

       Service Pack 2 for SQL Server 2016

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References


Learn about the terminology that Microsoft uses to describe software updates.