[jira] [Commented] (FINERACT-1851) Modify ReadMe.md to address default character set issue with windows
[ https://issues.apache.org/jira/browse/FINERACT-1851?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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)
[jira] [Commented] (FINERACT-1851) Modify ReadMe.md to address default character set issue with windows
[ https://issues.apache.org/jira/browse/FINERACT-1851?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17726784#comment-17726784 ] Francis Guchie commented on FINERACT-1851: -- Thank you [~kigred.developer] , I have been deploying on windows alike with no more issues for the currency is mentioned by you. Its a +1 from me that this has been resolved. Kindly advise if I should close this as resolved > 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)
