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')]
>>
>>

Reply via email to