...

The default selection in IIS may look like this.

...

MySQL Database Settings

Data Sorting

There are settings in the MySQL database that affect how data is sorted by the MySQL engine. It is controlled by the Character Set and Collation settings of the table and columns involved.

By default the Chameleon/Tick-it system uses utf8mb4 and utf8mb4_unicode_ci as the Character Set and Collations respectively.

To correctly handle special characters from a specific language it might be necessary to apply a different collation to the tables involved.

Example

To properly sort characters such as: Æ,Ø and Å in Danish the following code could be used to modify the db for elections and stories.

ALTER TABLE elc_event CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_danish_ci ;
ALTER TABLE elc_office CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_danish_ci ;
ALTER TABLE elc_party CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_danish_ci ;
ALTER TABLE elc_candidate CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_danish_ci ;
ALTER TABLE elc_area CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_danish_ci ;
ALTER TABLE story_topic CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_danish_ci ;
ALTER TABLE story_playlist CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_danish_ci ;