Orderables are sorted differently locally than on the test and UAT servers

Description

I noticed that orderables are sorted differently on uat.openlmis.org/test.openlmis.org and locally on ref-distro.
For example product with name '1.8 oz Armstrong Hand Sanitizer with Aloe Vera and Vitamin Ev' is in a different position on the test.openlmis.org and locally on ref-distro.
This may be due to the different SQL versions may have different default collation/sorting settings.

Acceptance Criteria
Check the collation/sorting settings on uat.openlmis.org/test.openlmis.org and locally on ref-distro.
Records should be sorted identically on uat.openlmis.org/test.openlmis.org and locally.

I noticed the same problem on the facilities list.

Environment

None

Assignee

Unassigned

Reporter

Aleksandra Sołtys

Labels

Epic Link

Components

Priority

Major
Configure