lr插入mysql的数据乱码

SHOW VARIABLES LIKE 'character_set_%';
SHOW VARIABLES LIKE 'collation_%';

input {
  jdbc {
    ...
    connection_string => "jdbc:mysql://localhost:3306/mydatabase?useUnicode=yes&characterEncoding=UTF-8"
    ...
  }
}

output {
  elasticsearch {
    ...
    hosts => ["http://localhost:9200"]
    ...
  }
}

jdbc_connection_string => "jdbc:mysql://localhost:3306/mydatabase?useUnicode=yes&characterEncoding=utf8mb4"

input {
  jdbc {
    jdbc_driver_library => "/path/to/mysql-connector-java-8.0.23.jar"
    jdbc_driver_class => "com.mysql.cj.jdbc.Driver"
    jdbc_connection_string => "jdbc:mysql://localhost:3306/mydatabase?useUnicode=yes&characterEncoding=utf8mb4"
    jdbc_user => "username"
    jdbc_password => "password"
    statement => "SELECT * FROM mytable"
  }
}

output {
  elasticsearch {
    hosts => ["http://localhost:9200"]
    index => "myindex"
  }
}