flyway迁移数据中文乱码

Question

Gradle配置如下：
buildscript {
repositories {
mavenCentral()
}
dependencies {
classpath 'mysql:mysql-connector-java:5.1.30'
classpath 'org.flywaydb:flyway-gradle-plugin:3.0'
}
}
apply plugin: "flyway"
flyway {
url = 'jdbc:mysql://localhost:3306/'
user = 'root'
password = ''
schemas = ['xx', 'xxx']
}
SQL文件本身是utf8的，表的创建也是指定了utf8
请教各位前辈，还需要设置些什么才不会乱码啊?

Answer 1

jdbc:mysql://localhost:3306/

改成

jdbc:mysql://localhost:3306/?useUnicode=true&characterEncoding=utf8&mysqlEncoding=utf8