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