handle_invalid_utf8.rs

use rusqlite::types::{FromSql, FromSqlError, FromSqlResult, ValueRef};

#[derive(Debug, Clone, PartialEq)]
pub struct LossyString(pub String);

impl FromSql for LossyString {
    fn column_result(value: ValueRef<'_>) -> FromSqlResult<Self> {
        if let ValueRef::Text(bytes) = value {
            let fixed = String::from_utf8_lossy(bytes).to_string();
            Ok(Self(fixed))
        } else {
            Err(FromSqlError::InvalidType)
        }
    }
}

// then use `row.get::<_, LossyString>()` or `row.get::<_, Option<LossyString>>()`...