Microsoft KB Archive/201776

= SMS: Double-Byte Character Set Name Sorting Limitation In Mixed Code Page Environment =

Article ID: 201776

Article Last Modified on 10/27/2006

-

APPLIES TO


 * Microsoft Systems Management Server 2.0 Standard Edition

-



This article was previously published under Q201776



SUMMARY
When you are querying the "All users" collection in the Systems Management Server Administrator Console, user names in the double-byte character set (DBCS) are not sorted correctly.



MORE INFORMATION
The sort order shown in the Systems Management Server Administrator Console is returned by Microsoft SQL Server. SQL Server does not allow more than one sort order in a mixed code page environment.

NOTE: Most European fonts, including all ISO8859 code sets, are single-byte fonts. Most Asian font sets, including the JIS (Japanese Kanji) fonts, are double-byte fonts.

If a site hierarchy includes computers using different code pages, you must name all network resources by using the standard ASCII characters (codes 0 through 127). This includes all computer names, share names, user names, user group names, domain names, and site codes. If computers in your SMS site hierarchy all use a common code page, there are no language-specific restrictions on network resource names.

Additional query words: prodsms sms20 query smssql

Keywords: kbcollections kbconfig kbdatabase kbinfo kbinterop kbnofix kbquery kbserver kbsmsadmin kbsmsprovider KB201776

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.