Microsoft KB Archive/302747

= INF: Japanese_Unicode Collation is Not Supported on Windows 2000 =

Article ID: 302747

Article Last Modified on 10/16/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q302747



SUMMARY
A SQL Server 2000 server that sets up a collation with Japanese_Unicode returns LCID 0x10411(66577) to a client. However, LCID 0x10411 is not supported on Windows 2000 and later.

WORKAROUND
Customers who have already configured SQL Server with Japanese_Unicode can use LCID 0x411 instead of 0x10411 in the client application.



MORE INFORMATION
SQL Server can emulate the sort order of Japanese_Unicode. However, you cannot use Japanese_Unicode in a general application that depends on the operating system for sort ordering.

When you specify LCID 0x10411 in a connection string, as follows, you cannot connect to SQL Server on a Windows 2000-based computer: objConn.Open &quot;Provider=SQLOLEDB;Locale Identifier=0x10411;Data Source=...;&quot;

Additional query words: locale LCID W2K

Keywords: kbinfo KB302747

-

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

© Microsoft Corporation. All rights reserved.