CODE EXAMPLE FOR JAVA

spring data sql not utf8

// For full UTF-8 setup, the following should work

spring.datasource.url=jdbc:mysql://localhost/schemaName?useTimezone=true
&serverTimezone=UTC&useUnicode=true&characterEncoding=UTF-8
  
// If using data.sql for data init. 
  
spring.datasource.sqlScriptEncoding=UTF-8