BUG: Double-Byte Character Set Insertion May Fail w/ Error 2627

• Microsoft SQL Server, versions 6.0 and 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 versions 6.0 and 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.