Learn for Life!

ORDER BY Oracle vs. Microsoft SQL


Like you would think ORDER BY is the same in Oracle as in the Microsoft environment, it isn’t. It depends on the Collation of the database. In the following example you see, that two manually added text in Oracle and Microsoft don’t order the same. After I added the Collation for SQL_Latin1_General_CP850_BIN2, it ordered the same.

ORDER BY Oracle:



 

ORDER BY Microsoft – normal and with collation:



 … Read more

Like you would think ORDER BY is the same in Oracle as in the Microsoft environment, it isn’t. It depends on the Collation of the database. In the following example you see, that two manually added text in Oracle and Microsoft don’t order the same. After I added the Collation for SQL_Latin1_General_CP850_BIN2, it ordered the same.

ORDER BY Oracle:

ORDER BY Oracle

 

ORDER BY Microsoft – normal and with collation:

ORDER BY Microsoft

 

1,053 total views, 1 views today


Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.