When creating tables in MySQL through Data Virtuality (e.g. when using MySQL as analytical storage) the charset of newly created tables will depend on the locale of your Java Virtual Machine (JVM).
In some cases, this may not be UTF-8 but you still want to create tables in MySQL using UTF-8. To do so, you may override the locale by editing your MySQL data source and set JDBC parameters to characterEncoding=UTF-8&useUnicode=true.
Please sign in to leave a comment.