INF: Japanese_Unicode Collation is Not Supported on Windows 2000
This article was previously published under Q302747
This article has been archived. It is offered "as is" and will no longer be updated.
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.
WORKAROUNDCustomers who have already configured SQL Server with Japanese_Unicode can use LCID 0x411 instead of 0x10411 in the client application.
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 "Provider=SQLOLEDB;Locale Identifier=0x10411;Data Source=...;"
locale LCID W2K
Article ID: 302747 - Last Review: 01/16/2015 23:01:47 - Revision: 3.2
- Microsoft SQL Server 2000 Standard Edition
- kbnosurvey kbarchive kbinfo KB302747