[
https://issues.apache.org/jira/browse/FINERACT-1851?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726840#comment-17726840
]
Kigenyi Wilfred commented on FINERACT-1851:
-------------------------------------------
Yes [~francisguchie] you can close the issue. Happy to be part of the community.
> Modify ReadMe.md to address default character set issue with windows
> --------------------------------------------------------------------
>
> Key: FINERACT-1851
> URL: https://issues.apache.org/jira/browse/FINERACT-1851
> Project: Apache Fineract
> Issue Type: Improvement
> Components: Docs
> Affects Versions: 1.8.2
> Environment: Windows
> Reporter: Kigenyi Wilfred
> Priority: Blocker
> Labels: documentation
> Fix For: 1.9.0
>
>
> 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.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
