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