C# string sorting VS Oracle string sorting?

Oracle can sort in several ways. By default Oracle will sort strings (VARCHAR) in a binary way, ie: strings will be sorted by the numeric values of each character in the database character set.

Oracle can sort in several ways. By default Oracle will sort strings (VARCHAR) in a binary way, ie: strings will be sorted by the numeric values of each character in the database character set. SQL> select * from nls_session_parameters where parameter like '%SORT%'; PARAMETER VALUE ---------- ---------- NLS_SORT BINARY SQL> SELECT rownum, chr(ROWNUM) FROM dual CONNECT BY LEVEL alter session set nls_sort=french; Session altered SQL> SELECT rownum, chr(ROWNUM) FROM dual CONNECT BY LEVEL.

You can implement a custom class derived from StringComparer to exactly replicate the results. However, Oracle's string sorting likely is determined by the collation used in the database/table/query so when using the same culture for sorting you may get the same results already without resorting to writing too much on your own.

You could create your own IComparer class, and use that instance to sort your list of strings. List has a member method 'Sort' which takes an IComparer or Comparision, in which you can implement your order-logic.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions