FIX: An access violation occurs when a database table name contains Japanese characters in SQL Server 2012 or SQL Server 2014

Symptoms
You create a database collation for the Japanese language locale in Microsoft SQL Server 2012 or SQL Server 2014. For example, you create a collation that's named Japanese_CI_AS. You create a table that contains Japanese characters in the table name. When you change the indexes of the table, an access violation occurs.
Resolution
To resolve this problem, apply this update, and then enable trace flag TF9394. To enable trace flag TF9394, see the "More Information" section.

Cumulative Update information

This issue was first fixed in the following cumulative update for SQL Server:
Recommendation: Install the latest cumulative update for SQL Server

Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:
Workaround
To work around this issue, re-create the objects by using named constraints that contain only English character sets.
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.
Properties

Article ID: 3142595 - Last Review: 05/31/2016 07:10:00 - Revision: 5.0

Microsoft SQL Server 2012 Developer, Microsoft SQL Server 2012 Enterprise, Microsoft SQL Server 2012 Standard, Microsoft SQL Server 2014 Service Pack 1, Microsoft SQL Server 2014 Developer, Microsoft SQL Server 2014 Enterprise, Microsoft SQL Server 2014 Standard

  • kbqfe kbfix kbfixme kbexpertiseinter kbsurveynew KB3142595
Feedback