Hi @hafriz
Please post “Diagnostic Info” from Admin > Troubleshooting.
Metabase requires the collation utf8mb4_unicode_ci - and I don’t understand how you’re getting that error.
Hi @flamber, i’m using percona mysql 8. You mean that the reason might because i’m using h2 application database and your advise to change it to mysql right?
@hafriz Okay, try adding this to the connection string in Admin > Databases > (your MySQL): useUnicode=true&characterEncoding=UTF-8 or detectCustomCollations=true
Could it be that a column or the database itself is not using utf8mb4_unicode_ci ?
It sounds like it’s an issue with MySQL: https://bugs.mysql.com/bug.php?id=101346
You should never use H2 if you are using Metabase in production, but changing that will not fix the problem you are currently having.
Thanks a lot, it seems the column not in the same colation with other joined column. thanks, after changing by adding COLLATE utf8mb4_unicode_ci it seems working now.
also thanks for the suggestion to change to mysql for application. i try doing it now
by the way, is there any guide that i can follow to copy metabase.db to external folder? so then after that i can point the docker to new metabase.db path before migrate it to mysql
@hafriz I would recommend doing migration with JAR file instead of with Docker, since it’s simpler if you’re not advanced Docker user, and since the migration is a one-off process.