[FINERACT-1851] Modify ReadMe.md to address default character set issue with windows

• Type: Improvement
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 1.8.2
• Fix Version/s: 1.7.3, 1.8.4, 1.8.3, 1.8.2
• Component/s: Docs
• Labels: documentation
• Environment: Windows
• Flags: Important

Language

Java

• Assignee: Unassigned
• Reporter: Kigenyi Wilfred
• Created: 10/Jan/23 10:28
• Updated: 04/Sep/23 04:01
• Resolved: 28/May/23 13:46

Description

When creating databases and tables with mysql/mariadb on Windows servers, the default character set is UTF8MB3. The character set UTF8MB3 allows for columns to store up to 3 bytes.

The display_symbol column in the fineract_default.m_currency table requires 4bytes, so if the default character set is used when creating the database fineract_default with the following command:

CREATE DATABASE fineract_default

then the migration script to insert the currencies will fail with an error similar to:

Incorrect string value: `\xE2\x82\xA1` for column display_symbol ...

To rectify this, the default character set has to be overridden when creating the fineract_default database with the following command

CREATE DATABASE fineract_default CHARACTER SET utf8mb4

This allows for the 4bytes needed to store the data in the m_currency.display_symbol and the migration script will run just fine.

Issue Links

• links to: GitHub Pull Request #2874