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

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 : winnt:6.0
Platform : winnt
Issue type :