There are aspects of the displayed data in Flow that are determined by the current culture setting. This applies to how numbers and dates are displayed.

IIS Setting

To change the culture setting for a website in IIS (Internet Information Services Manager) you:

Select the website you want to configure
Double-click on the .NET Globalization icon
Change the selections to the desired culture option from the lists for both
1. Culture
2. UI Culture
Click the Apply link in the right hand actions pane

Typical Default Selections

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 ;