KB165051 - INF: Installing a DBCS Code Page for SQL Server

Article ID: 165051

Article Last Modified on 11/21/2003

Microsoft SQL Server 6.0 Standard Edition
Microsoft SQL Server 6.5 Standard Edition

This article was previously published under Q165051

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.

Log on to Windows NT Server to an account with Administrator privilege.
Copy the code page file to the %SystemRoot%\System32 directory.
Start Registry Editor (Regedt32.exe) and locate the following HKEY_LOCAL_MACHINE subtree:
```
      System\CurrentControlSet\Control\Nls\CodePage

						
```
On the Edit menu, click Add Value.

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)

Locate the following HKEY_LOCAL_MACHINE subtree:

      System\CurrentControlSet\Control\Nls\Language

On the Edit menu, click Add Value.

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

Quit Registry Editor.
Shut down and restart the computer running Windows NT Server.
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.

Log on to Windows NT Server to an account with Administrator privilege.
Start the Windows NT Explorer.
Insert the Windows NT Server 4.0 compact disc.
In the Langpack directory, locate the .inf file named appropriately for the language.
Right-click the .inf file you want to add support for.
Click Install on the context menu.
When it has completed adding the language, shut down and restart the computer running Windows NT Server.
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.)

For additional information on adding language support, see the following article in the Microsoft Knowledge Base:

177561 HOWTO: Add and Enable Additional Languages in Windows NT

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: kbhowto kbinterop kbenv KB165051