UnicodeIUC22
Program Showcase Registration Accommodation Travel Sponsors
Unicode Standard Conference Board Conference CD Last Conference Past Conferences Next Conference
Abstract

Extending the Sorting Capabilities of Relational Databases

Steve Miller - SIL International

Intended Audience: Managers, Software Engineers, Systems Analysts, Database Analysts and Developers
Session Level: Intermediate, Advanced

Current relational database management systems (RDMSs), such Microsoft (MS) SQL Server, have the ability to sort data for major languages, but they do not have the ability to sort properly for many of the lesser-known languages around the world. Moreover, MS SQL Server sorting uses MS Windows collations, and collations cannot be added to Windows. A software developer is limited by the operating system.

We have chosen to use IBM's International Components (ICU) for Unicode to address these shortcomings. More specifically, we are using the Collation Services of ICU. The services can be "tailored" for different languages and locales; theoretically any language of the world can be sorted. We are accessing the Collation Services by extending the capabilities of the database. In the case of MS SQL Server, we do this by means of an "extended stored procedure". This extended stored procedure is a C++ project compiled as a dll.

Although MS SQL Server is used in this example, the approach can be used with other RDMSs. It has the potential to be a powerful factor in bridging the "digital divide" encountered by many computer users in developing nations.


Unicode
When the world wants to talk, it speaks Unicode

UnicodeIUC22
Program Showcase Registration Accommodation Travel Sponsors
Unicode Standard Conference Board Conference CD Last Conference Past Conferences Next Conference
International Unicode Conferences are organized by Global Meeting Services, Inc., (GMS). GMS is pleased to be able to offer the International Unicode Conferences under an exclusive license granted by the Unicode Consortium. All responsibility for conference finances and operations is borne by GMS. The independent conference board serves solely at the pleasure of GMS and is composed of volunteers active in Unicode and in international software development. All inquiries regarding International Unicode Conferences should be addressed to info@global-conference.com.

Unicode and the Unicode logo are registered trademarks of Unicode, Inc. Used with permission.

12 Jun 2002, Webmaster