INF: Japanese_Unicode Collation is Not Supported on Windows 2000 (302747)


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)
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 "Provider=SQLOLEDB;Locale Identifier=0x10411;Data Source=...;"
Modification Type:MajorLast Reviewed:10/16/2003
Keywords:kbinfo KB302747
©2003 Microsoft Corporation. All rights reserved.