FIX: Repl w/ Ext Chars on Non-ANSI Char Sets May Fail

ID: Q138291

The information in this article applies to:

Microsoft SQL Server, version 6.0

BUG# NT: 11374 (6.00)

SYMPTOMS

Extended character values embedded in SQL statements, such as an INSERT command, can be incorrectly distributed by the LogReader on servers installed with non-ANSI character sets. In most situations, the values will appear as unreadable characters. In other situations, it could cause the command to fail with a syntax error when applied to the subscriber.

CAUSE

The sp_replcmds procedure used by the LogReader is using an ANSItoOEM conversion which can cause extended characters on non-ANSI servers to become unreadable.

STATUS

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

Additional query words: sql6 windows nt

Keywords          : kbprg SSrvProg SSrvStProc kbbug6.00 kbfix6.00.sp1 
Version           : 6.0
Platform          : WINDOWS

Last Reviewed: May 2, 1997