Knowledge Base

FIX: Replication of Japanese DBCS Character Fails

Article ID: 160146

Article Last Modified on 10/3/2003


APPLIES TO


This article was previously published under Q160146
BUG #: 15807

SYMPTOMS

When you use SQL Server replication with the code page 932 installed, some replication commands may not be successfully run, resulting in some Japanese characters being mistakenly replicated in the subscribing table.

CAUSE

When SQL Server replicates, the T-SQL command performed is stored in the command column of the MSJob_commands table. If the performed T-SQL command is greater than 255 bytes, the T-SQL command is stored into two or more rows in the MSJob_commands. If the 255th byte of data is a Double-byte Character Set (DBCS) character, SQL Server truncates the lead byte of this double-byte character, and places the trailing byte at the next row. For example, if the double-byte character "8341" is at that critical location, it will be replicated as "2041". This results in " A" appearing in the subscribing table. In some cases, the distribution task fails as well.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server version 6.5. For more information, contact your primary support provider.

Additional query words: Japanese

Keywords: kbbug kbfix kbusage KB160146