Skip to Content
Former Member
Feb 23, 2010 at 06:04 PM

Sorting an alphanumeric feild does not produce same sort order as Oracle


There is a sorting problem with Business Objects such that the sorted results from a database is different from the sorted results within Business Objects (Desktop Intelligence or Web Intelligence).

For example, consider this sample list of last names: Dennis, de Boer, Obbanty, Danson, O Brien, Davis

(NOTE: the space in O Brien)

database results sorted: Danson, Davis, Dennis, O Brien, Obbanty, de Boer

BO results sorted: Danson, Davis, de Boer, Dennis, Obbanty, O Brien

Is there a way to get the saem sorting order as Oracle's ORDER BY clasue in Deski XIR2?