Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Access databases that contain Chinese characters do not sort correctly in Access Services for SharePoint 2010

View products that this article applies to.


Consider the following scenario:
  • You have a server that is running Microsoft SharePoint Server 2010 with Access Services in Microsoft SharePoint Server 2010.
  • The server language locale is Chinese (Simplified PRC).
  • The language locale of a client computer is Chinese (Simplified PRC).
  • You publish a Microsoft Access 2010 database from the client computer.�
  • You open the published database and�locate a table�that contains Chinese characters.�
  • You select an ascending sort for a column that contains Chinese numbers.
In this scenario, the column does not sort as expected. You notice that the numbers are not sorted correctly in ascending order.

If you use Access 2010 to sort the database table on the same column, the table sorts correctly.

↑ Back to the top


This issue occurs because Access Services on SharePoint 2010 supports backward compatibility with earlier versions of Access. Microsoft Office Access 2007 and earlier versions use an older style of sorting Chinese characters that does not correctly weight every Chinese number.

↑ Back to the top

Keywords: KB983040, kbdatabase, kbtshoot, kbexpertiseinter, kbsurveynew, kbprb

↑ Back to the top

Article Info
Article ID : 983040
Revision : 2
Created on : 4/7/2011
Published on : 4/7/2011
Exists online : False
Views : 426