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
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: October 16, 2003 - Revision: 3.2
APPLIES TO
  • Microsoft SQL Server 2000 Standard Edition
Keywords: 
kbinfo KB302747

Give Feedback

 

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