We have to do Danish language based sorting for the records coming from DB
In SQL we are giving default sorting which is based on Danish NLS
E.g. select * from tablename ORDER by NLSSORT(code, 'NLS_SORT=danish') which is coming proper
In UI we have screen which accepts these sorting given done above SQL .User can click on the header of the column of table (where all the records are populated)
To do the sorting and we need sorting based on same Danish nls so in UI we are using Collator to sort according to Danish language the sample code is as below :
But the problem is, retreived result from above two are different i.e from SQL and Core Java, please advice what needs to be done.
I am resubmitting the problem with code tag.