Category: Business Intelligence

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 Microsoft – normal and with collation:

 …

Read more