If you use sorting functions such as running-totals in reports, you may need to add a collation sequence to the database connection string to maintain data integrity. Otherwise, when sorting a report that is grouped by one or more columns containing foreign characters, you may get inconsistent results. This is because without the collation sequence information, the default locale is used to sort data, whereas databases may use different collations in their sorting.

To prevent sorting inconsistencies, you must add the correct collation sequence to your database connection string when you create a data source or add a connection.

For example, in Oracle, if you specify the collation sequence as Binary at the database level, you should provide the same collation sequence value in the connection string.