I have faced this before. If you are using Windows then when creating the fineract_default database you will to specify a character set that supports the currency symbols. So drop the fineract_default database and create it using the following command: create database fineract_default character set utf8mb4;
Then continue with the other steps. Wilfred. On Tue, 10 Jan 2023, 10:48 Ippez Robert, <ippezrob...@gmail.com> wrote: > *Steps to reproduce:-* > 1. Clone fineract locally > 2. Create a jar file using command `./gradlew clean bootJar` > 3. Create the required databases using `./gradlew createDB > -PdbName=fineract_tenants` and `./gradlew createDB > -PdbName=fineract_default` > 4. Run `java -jar fineract-provider/build/libs/fineract-provider.jar` to > start the application. NB: You can rename the generated jar in build > directory or copy its generated name > > *Migration failed for changeset > db/changelog/tenant/parts/0002_initial_data.xml::14::fineract: * > > > > > > > > > *Caused by: liquibase.exception.DatabaseException: (conn=3236) Incorrect > string value: '\xE2\x82\xA1' for column 'display_symbol' at row 1 [Failed > SQL: (1366) INSERT INTO fineract_default.m_currency (id, code, > decimal_places, currency_multiplesof, display_symbol, name, > internationalized_name_code) VALUES (32, 'CRC', 2, NULL, 'Γéí', 'Costa > Rican Colon', 'currency.CRC')] at > liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:446) > at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:78) > at > liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:161) > at > liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1270) > at > liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1252) > at liquibase.changelog.ChangeSet.execute(ChangeSet.java:685) > ... 154 common frames omitted* > > Thanks and Regards > > *Ippez Robert* >
