How to change type of sorting
Posted: Wed 10 Nov 2010 12:53
Hello,
we use dotConnect 5.70.120.00 with MS entity framework. Nearmost everything works well, but the sorting seems to be ASCII instead of national letters. So big letter words were shown prior to smal letter words.
This is wrong for our customer. We try to use NLS_SORT and ALTER SESSION. This works well when we connect direct to the database. But where can we set this value inside our sw-solution? How is it possible to change sorting?
Thanks
Roman
we use dotConnect 5.70.120.00 with MS entity framework. Nearmost everything works well, but the sorting seems to be ASCII instead of national letters. So big letter words were shown prior to smal letter words.
This is wrong for our customer. We try to use NLS_SORT and ALTER SESSION. This works well when we connect direct to the database. But where can we set this value inside our sw-solution? How is it possible to change sorting?
Thanks
Roman