We experience a sorting issue in our SDL Tridion 2011 SP1 implementation. Our CM uses numbers to sort structure groups but Tridion sorts first letters and then numbers. We use Oracle 11g. What we found is that there is one environment lcmAcc that behaves the correct way. Means that it sorts first numbers and then letters. After testing and connecting different DB's (all Oracle 11g) we concluded that is not a DB issue but a setting on the Server. Whatever DB we connect with the lcmAcc (windows server) environment behaves as we want. Could it be a Tridion configuration setting that does the job or the Oracle client installed there? Can anybody give us a tip? As I see the question was asked a year ago. Quirijn did you figured it out?
Sort order on Oracle is determined by the NLS_SORT parameter on the Oracle Client. Perform the steps below to set NLS_SORT to BINARY, or choose a NLS_LANG setting that includes binary.
according to some oracle docs
So ensure these are the same across all installed oracle clients used to connect to Tridion databases.
As a temporary measure you could implement a Data List Extender, take a look at the docs:
All you'll have to do is re-sort the xml nodes by the Title attribute using .Net. This way you ensure you see the sorting like you want (regardless of the database) and even you can then use this mechanism to apply more rules when sorting.