Article ID: 302747 - Last Review: October 16, 2003 - Revision: 3.2

INF: Japanese_Unicode Collation is Not Supported on Windows 2000

View products that this article applies to.
System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.
This article was previously published under Q302747

On This Page

Expand all | Collapse all

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.
Back to the top

WORKAROUND

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

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=...;"
Back to the top
APPLIES TO
  • Microsoft SQL Server 2000 Standard Edition
Back to the top
Keywords: 
kbinfo KB302747
Back to the top