FIX: Double-Byte Character Set Insertion May Fail with Error 2627

• Microsoft SQL Server versions 6.0, 6.5

SYMPTOMS

A double-byte character set (DBCS) insertion may fail with error 2627 when SQL Server is configured with the code page 850 Multilingual character set and sort order 42 (dictionary order, case-insensitive sort order). The following scripts demonstrate this problem:

CREATE TABLE t
   (
    aChar VARCHAR (2) PRIMARY KEY CLUSTERED,
    code BINARY(2)
   )
   GO

   SET NOCOUNT ON
   DECLARE @code BINARY(2)
   DECLARE @aChar VARCHAR(2)
   SELECT @code = 0x88a4
   WHILE @code < 0x88a6
   BEGIN
     SELECT @code
     SELECT @aChar = convert(VARCHAR(2), @code)
     SELECT @aChar
     INSERT t (aChar, code) VALUES (@aChar, @code)
     SELECT @code = @code + 1
   END 

WORKAROUND

To work around this problem, use another code page.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 6.5. This problem has been corrected in U.S. Service Pack 5a for Microsoft SQL Server version 6.5. For information about downloading and installing the latest SQL Server Service Pack, see http://support.microsoft.com/support/sql/.

For more information, contact your primary support provider.

Additional query words: JIS Wansung Johab Hangul KB BIG-5

Keywords          : kbenv SSrvGen SSrvTran_SQL kbbug6.50 kbfix6.50.SP5 
Version           : winnt:6.0,6.5
Platform          : winnt 
Issue type        : kbbug 

Last Reviewed: July 14, 1999