INF: Installing a DBCS Code Page for SQL Server

Last reviewed: April 22, 1997
Article ID: Q165051
The information in this article applies to:
  • Microsoft SQL Server, versions 6.0 and 6.5

SUMMARY

This article describes how to manually add double-byte character set (DBCS) code pages for languages that are not supported by default in non-localized versions of Windows NT Server 3.51 or 4.0. When installing SQL Server with a DBCS code page (such as cp-932, cp-936, cp-949, or cp-950), the user has one choice of the following sort orders:

  • Dictionary order, case-insensitive (provided by Windows NT Server)
  • Binary order
  • Customer

Note that for the Dictionary order, the user must first install the appropriate code page on the computer running Windows NT Server so that a case-insensitive sort order can function properly. There are two possible methods to add DBCS code pages to non-localized versions of Windows NT Server 3.51 or 4.0.

MORE INFORMATION

Method One: Manually Add the DBCS Code Page to the Registry

NOTE: This option is available for computers running Windows NT Server version 3.51 or 4.0.

WARNING: Using Registry Editor incorrectly can cause serious, system-wide problems that may require you to reinstall Windows NT to correct them. Microsoft cannot guarantee that any problems resulting from the use of Registry Editor can be solved. Use this tool at your own risk.

  1. Log on to Windows NT Server to an account with Administrator privilege.

  2. Copy the code page file to the %SystemRoot%\System32 directory.

  3. Start Registry Editor (Regedt32.exe) and locate the following HKEY_LOCAL_MACHINE subtree:

          System\CurrentControlSet\Control\Nls\CodePage
    

  4. On the Edit menu, click Add Value.

  5. Enter the following values:

          Value Name: <code page number> (for example, 950)
          Data Type: REG_SZ
          String: <code page file name> (for example, C_950.NLS)
    

  6. Locate the following HKEY_LOCAL_MACHINE subtree:

          System\CurrentControlSet\Control\Nls\Language
    

  7. On the Edit menu, click Add Value.

  8. Enter the following values:

          Value Name: <local-specific code page ID> (for example, 0404 for code
    
                      page 950; see the "Local-Specific Code Page Information"
                      section of this article for the specific local IDs)
          Data Type: REG_SZ
          String: l_intl.nls
    
    

  9. Quit Registry Editor.

  10. Shut down and restart the computer running Windows NT Server.

  11. Install SQL Server with the desired DBCS code page and sort order (or rebuild the SQL Server master database with the desired DBCS code page, if SQL Server is already installed.)

Method Two: Add the Code Page by Means of an .Inf Script

NOTE: This option is available for computers running Windows NT Server 4.0.

  1. Log on to Windows NT Server to an account with Administrator privilege.

  2. Start the Windows NT Explorer.

  3. Insert the Windows NT Server 4.0 compact disc.

  4. In the Langpack directory, locate the .inf file named appropriately for the language.

  5. Right-click the .inf file you want to add support for.

  6. Click Install on the context menu.

  7. When it has completed adding the language, shut down and restart the computer running Windows NT Server.

  8. Install SQL Server with the desired DBCS code page and sort order (or rebuild the SQL Server master database with the desired DBCS code page, if SQL Server is already installed.)

Local-Specific Code Page Information

Local                LCID          Code Page

Chinese (PRC)        0x0804           936
Chinese (Taiwan)     0x0404           950
Chinese (Hong Kong)  0x0c04           950
Chinese (Singapore)  0x1004           936
Japanese             0x0411           932
Korean               0x0412           949


Additional query words: JIS Wansung Johab Hangul KB BIG-5
Keywords : SSrvGen SSrvInst kbenv kbinterop
Version : 6.5
Platform : WINDOWS
Issue type : kbhowto
Solution Type : Info_Provided


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 22, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.