When the vachar field stored in the MySQL database is encoded in Latin1, the query results are garbled

[easy-do]

As the title suggests, I am working on a database table in MySQL that contains varchar fields. But strangely, the original program used Latin1 encoding to store the table in the database. When I use the entity generated by sea orm for querying, the query result string will display garbled characters. Can the garbled code problem be directly solved through configuration, or do we need to manually convert it in the code after querying the database using other methods? Using Unicode=true&charcterEncoding=latin1 parameter, and executing "SET NAMES latin1" before executing native SQL to obtain query results, then manually converting the string encoding can solve the problem.

This is a Java code example：

            DruidDataSource ds = flexDataSourceUtil.getDataSource("taiwan_cain");
            Connection conn = ds.getConnection();
            Statement stat = conn.createStatement();
            conn.prepareStatement("SET NAMES latin1").execute();
            String sql = "SELECT charac_no,charac_name FROM charac_info";
            ResultSet rs = stat.executeQuery(sql);

    public static String convertUtf8(String content){
        return CharsetUtil.convert(content,"latin1","utf8");
    }

I always find a good solution to this problem when using Java language, but for Rust language, I am still a novice. If someone who can solve this problem can also ask and teach me, thank you very much