Use unicode binary collating sequence for MySQL/MariaDB, SQL Server

Current Situation

• JS7 uses case-insensitive behavior for all supported DBMS to create configuration items such as Folder, Workflow, etc.
  • This behavior prevents the existence of, for example, a test and a Test workflow at the same time.
  • However, it is possible to rename an existing item using a different spelling, e.g., test -> Test.
• With a case-insensitive and accent-insensitive database collation, the following applies:
  • The database considers Resume and Résumé as the same value, so differentiated configuration objects cannot be created.
  • Database key constraints treat these variations as duplicates, which may cause constraint violations.

Desired Behavior

• JS7 uses case-insensitive creation behavior and the Java-based sorting remains as is.
• Using a binary collation for MySQL/MariaDB and SQL Server databases would allow the database to treat case and accent variations as distinct values.