IOhacker commented on code in PR #4400:
URL: https://github.com/apache/fineract/pull/4400#discussion_r1977868435
##########
fineract-core/src/main/java/org/apache/fineract/infrastructure/core/service/database/DatabaseSpecificSQLGenerator.java:
##########
@@ -161,7 +161,7 @@ public String dateDiff(String date1, String date2) {
public String castChar(String sql) {
if (databaseTypeResolver.isMySQL()) {
- return format("CAST(%s AS CHAR)", sql);
+ return format("CAST(%s AS CHAR) COLLATE utf8mb4_unicode_ci", sql);
Review Comment:
@adamsaghy I have added in the Jira ticket the error that is faced now.
Seems that by default the CAST function is using utf8mb4_general_ci
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
