INF: Japanese_Unicode Collation is Not Supported on Windows 2000

Article translations Article translations
Article ID: 302747 - View products that this article applies to.
This article was previously published under Q302747
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

On This Page

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=...;"
				

Properties

Article ID: 302747 - Last Review: January 16, 2015 - Revision: 3.2
APPLIES TO
  • Microsoft SQL Server 2000 Standard Edition
Keywords: 
kbnosurvey kbarchive kbinfo KB302747

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com