DetailPage-MSS-KB

Microsoft small business knowledge base

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

This article was previously published under Q302747

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

APPLIES TO
  • Microsoft SQL Server 2000 Standard Edition
Keywords: 
kbinfo KB302747
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support