When doing a CM Import of a CM package from an Oracle RDBMS-based WebFOCUS repository into a sandbox with a MariaDB (aka MySQL) based repository, which was set up as a MariaDB (aka MySQL) based repository with the following statement "create database webfocus93 collate latin1_general_cs;"

Throws the error: mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Incorrect string value:'\xE6\xA8\x99

To resolve the issue, add “utf8mb4_unicode_ci” to the create database statement.

Example: create database webfocus93 collate utf8mb4_unicode_ci;

What are the correct CREATE DATABASE specifications for a MySQL(MariaDB)-based WebFOCUS 9.x repository database?

For more information, review: https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-sets.html