Microsoft KB Archive/165051

= INF: Installing a DBCS Code Page for SQL Server =

Article ID: 165051

Article Last Modified on 11/21/2003

-

APPLIES TO


 * 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.



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: (for example, 950) Data Type: REG_SZ String: (for example, C_950.NLS)   Locate the following HKEY_LOCAL_MACHINE subtree:

<pre class="fixed_text">     System\CurrentControlSet\Control\Nls\Language </li> On the Edit menu, click Add Value.</li>  Enter the following values:

<pre class="fixed_text">     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 </li> Quit Registry Editor.</li> Shut down and restart the computer running Windows NT Server.</li> 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.)</li></ol>

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.)

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
<pre class="fixed_text">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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.