[
https://issues.apache.org/jira/browse/FINERACT-2195?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17932022#comment-17932022
]
Victor Romero commented on FINERACT-2195:
-----------------------------------------
This is the error faced after creating a Fixed Deposit product
fineract-server-1 | 16:54:12.817 [https-jsse-nio-8443-exec-3] WARN
o.g.j.server.ServerRuntime$Responder - An exception mapping did not
successfully produce and processed a response. Logging the exception propagated
to the default exception mapper.
fineract-server-1 | org.springframework.jdbc.UncategorizedSQLException:
PreparedStatementCallback; uncategorized SQLException; SQL state [HY000]; error
code [1267]; (conn=168) Illegal mix of collations (utf8mb4_general_ci,IMPLICIT)
and (utf8mb4_unicode_ci,IMPLICIT) for operation '='
fineract-server-1 | at
org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1549)
fineract-server-1 | at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:677)
fineract-server-1 | at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:723)
fineract-server-1 | at
org.apache.fineract.portfolio.interestratechart.service.InterestRateChartReadPlatformServiceImpl.retrieveAllWithSlabs(InterestRateChartReadPlatformServiceImpl.java:99)
fineract-server-1 | at
org.apache.fineract.portfolio.interestratechart.service.InterestRateChartReadPlatformServiceImpl.retrieveAllWithSlabsWithTemplate(InterestRateChartReadPlatformServiceImpl.java:109)
fineract-server-1 | at
org.apache.fineract.portfolio.savings.api.FixedDepositProductsApiResource.retrieveOne(FixedDepositProductsApiResource.java:192)
fineract-server-1 | at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> UTF8 issue for Interest Rate Chart
> -----------------------------------
>
> Key: FINERACT-2195
> URL: https://issues.apache.org/jira/browse/FINERACT-2195
> Project: Apache Fineract
> Issue Type: Bug
> Reporter: Victor Romero
> Priority: Major
> Attachments: Interest_rate_issue.txt
>
>
> When using Maria DB the SQL Query cannot retrieve deposit products because
> whend doing cast to char it tries to use UTF-8 General instead of
> UTF-8Unicode
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
