Thanks for the help. It worked On Wed, 28 Jun 2023, 21:56 Kigred Developer, <kigred.develo...@gmail.com> wrote:
> From the screenshot you share it looks like you are using Windows > environment. > Make sure that as you create the database fineract_default, you specify a > charset that can support characters @Ádám Sághy <adamsa...@gmail.com> > highlighted > here. > > For example: > CREATE DATABASE fineract_default CHARSET UTF8MB4 > > Regards. > Wilfred. > On Wed, 28 Jun 2023, 21:54 Ádám Sághy, <adamsa...@gmail.com> wrote: > >> Relevant piece of error: >> >> Caused by: liquibase.exception.MigrationFailedException: Migration failed >> for change set >> db/changelog/tenant/parts/0002_initial_data.xml::14::fineract: >> Reason: liquibase.exception.DatabaseException: (conn=10) Incorrect >> string value: '\xE2\x82\xA1' for column >> `fineract_default`.`m_currency`.`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')] >> >> Seems your database engine using and a character encoding which does not >> support the above currency symbol. >> >> i hope it helps. >> >> Regards >> Adam >> >> Sent from my iPhone >> >> On 28 Jun 2023, at 20:45, Jamiu Ayomide Olawale <horlawaleja...@gmail.com> >> wrote: >> >> Caused by: liquibase.exception.MigrationFailedException: Migration failed >> for change set >> db/changelog/tenant/parts/0002_initial_data.xml::14::fineract: >> Reason: liquibase.exception.DatabaseException: (conn=10) Incorrect >> string value: '\xE2\x82\xA1' for column >> `fineract_default`.`m_currency`.`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')] >> >>