We are using NHibernate and Oracle for database access. During selection we are ordering data by text, but culture specific characters goes in the end of the list.
We want: AĀBCDEĒFG
We got: ABCDEFGĀĒ
In oracle docs we found that NLS_SORT
has to be set to BINARY_AI
to enable that kind of sorting.
Can you advice please if it is possible(and how) to set this parameter in NHibernate configuration or during connection initialization?
Thank you