Insertng long latin-1 encoded string into MSSQL varchar(max) column

[sportfloh]

Hi,

I need to insert a long latin-1 encoded string into a varchar(max) column in a MSSQL database.

My current attempt is:

let long_latin1_string: &[u8];

let long_latin1_string_blob = WithDataType {
    value: &mut BlobSlice::from_byte_slice(long_latin1_string).as_blob_param(),
    data_type: DataType::Varchar {
        length: NonZeroUsize::new(xml.len()),
    },
};
ms_connection.execute(sql_query, & long_latin1_string_blob)?;

I get this error:

error[E0277]: the trait bound `&mut odbc_api::parameter::BlobParam<'_>: odbc_api::parameter::CElement` is not satisfied
    |
215 |     ms_connection.execute(sql_query, &long_latin1_string_blob)?;
    |                   -------             ^^^^^^^^^^^^^^^^^^^^^^^ the trait `odbc_api::parameter::CElement` is not implemented for `&mut odbc_api::parameter::BlobParam<'_>`
    |                   |
    |                   required by a bound introduced by this call
    |
    = help: the following other types implement trait `odbc_api::parameter::CElement`:
              i8
              i16
              i32
              i64
              u8
              u16
              u32
              u64
            and 16 others
    = note: required for `odbc_api::parameter::WithDataType<&mut odbc_api::parameter::BlobParam<'_>>` to implement `odbc_api::parameter::CElement`
    = note: required for `odbc_api::parameter::WithDataType<&mut odbc_api::parameter::BlobParam<'_>>` to implement `odbc_api::parameter::InputParameter`
    = note: required for `odbc_api::parameter::WithDataType<&mut odbc_api::parameter::BlobParam<'_>>` to implement `odbc_api::parameter_collection::InputParameterCollection`
    = note: required for `&odbc_api::parameter::WithDataType<&mut odbc_api::parameter::BlobParam<'_>>` to implement `odbc_api::ParameterCollectionRef`
note: required by a bound in `odbc_api::Connection::<'c>::execute`
   --> /Users/user/.cargo/registry/src/index.crates.io-6f17d22bba15001f/odbc-api-5.1.0/src/connection.rs:119:22
    |
116 |     pub fn execute(
    |            ------- required by a bound in this associated function
...
119 |         params: impl ParameterCollectionRef,
    |                      ^^^^^^^^^^^^^^^^^^^^^^ required by this bound in `Connection::<'c>::execute`

For more information about this error, try `rustc --explain E0277`.

Any idears?

Thanks and cheers!

[sportfloh]

Aha, I think I found a solution:

let mut long_latin1_string_blob = BlobSlice {
    is_binary: false,
    blob: long_latin1_string,
    batch_size: long_latin1_string.len(),
};
ms_connection.execute(sql_query, &mut long_latin1_string_blob.as_blob_param())?;

[pacman82]

Yes. Not quite sure if you also found: https://docs.rs/odbc-api/latest/odbc_api/parameter/index.html#sending-long-data

Your use-case is a bit "edgy" because, you do have text, which is not UTF-8 encoded, so there is no convenient constructor for you, yet all the members of BlobSlice are public and you now filled them correctly.

[sportfloh]

Yes, I found that, but I was confused because of my edge case. Thanks!