Cannot get String from CTE Column

[ilhamfu]

    let mut qb = QueryBuilder::new("WITH my_id(id) AS (VALUES ");
    let mut sp = qb.separated(",");
    for code in new_codes {
        sp.push("(");
        sp.push_bind_unseparated(String::from(code));
        sp.push_unseparated(")");
    }
    qb.push(
        r#")
            SELECT m.id as new_id, d.code as old_id
            FROM my_id m
            RIGHT JOIN doctors d
            ON d.code = m.id
            "#,
    );
    debug!("{:?}", qb.sql());
    let codes = qb
        .build_query_as::<DoctorCode>()
        .fetch_all(pool)
        .await
        .context("failed when get doctors code")?;

#[derive(Debug,FromRow)]
pub struct DoctorCode {
    pub old_id: Option<String>,
    pub new_id: Option<String>,
}

trying to run above code, but i got this error

mismatched types; Rust type `alloc::string::String` (as SQL type `VARCHAR`) is not compatible with SQL type `BINARY`