# Case Insensitive Sorting in APEX

By default Oracle does case sensitive sorting, which means that ascending order goes from `A-Z` then `a-z`. This is reflected in APEX when creating reports and sorting on them.

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1704123069199/28e80409-b566-4036-8aa0-a01f193e17bb.png align="center")

They're various workarounds to enable case insensitive sorting. The simplest is to change the entire application by modifying the following setting in `Shared Components > Globalization > Character Value Comparison` to `BINARY_CI`:

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1704123088657/01bf5504-b758-4c77-8e5b-b5cecebfe184.png align="center")

Once set, all your reports will be sorted case insensitive. The first report now looks like this:

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1704123107029/bdd3d9c7-e860-4634-9a8d-8fa649bb81b4.png align="center")

*Thanks to* [*Jorge Rimblas*](https://twitter.com/rimblas) *for showing me this!*