Trait ToSql 

pub trait ToSql {
    // Required methods
    fn to_sql(&self) -> Result<SqlValue, TypeError>;
    fn sql_type(&self) -> &'static str;

    // Provided method
    fn encrypted_param_type(&self) -> Option<EncryptedParamType> { ... }
}

Trait for types that can be converted to SQL values.

This trait is implemented for common Rust types to enable type-safe parameter binding in queries.

Required Methods

fn to_sql(&self) -> Result<SqlValue, TypeError>

Convert this value to a SQL value.

fn sql_type(&self) -> &'static str

Get the SQL type name for this value.

Provided Methods

fn encrypted_param_type(&self) -> Option<EncryptedParamType>

The explicit SQL type a parameter must be declared and encrypted as, when the value alone cannot convey it.

Returns None for every type except the typed-parameter wrappers (e.g. numeric, datetime2, time). An Always Encrypted column requires the declared type — including precision, scale, or length — to match the column exactly, which a bare value cannot always express (a Decimal carries no precision; a NaiveDateTime is ambiguous between datetime and datetime2(n)). The driver uses this to declare the parameter for sp_describe_parameter_encryption and to normalize the value before encryption.

Dyn Compatibility

This trait is dyn compatible.

In older versions of Rust, dyn compatibility was called "object safety".

Implementations on Foreign Types

impl ToSql for DateTime<FixedOffset>

Available on crate feature chrono only.

fn to_sql(&self) -> Result<SqlValue, TypeError>

fn sql_type(&self) -> &'static str

impl ToSql for DateTime<Utc>

Available on crate feature chrono only.

fn to_sql(&self) -> Result<SqlValue, TypeError>

fn sql_type(&self) -> &'static str

impl ToSql for Decimal

Available on crate feature decimal only.

fn to_sql(&self) -> Result<SqlValue, TypeError>

fn sql_type(&self) -> &'static str

impl ToSql for NaiveDate

Available on crate feature chrono only.

fn to_sql(&self) -> Result<SqlValue, TypeError>

fn sql_type(&self) -> &'static str

impl ToSql for NaiveDateTime

Available on crate feature chrono only.

fn to_sql(&self) -> Result<SqlValue, TypeError>

fn sql_type(&self) -> &'static str

impl ToSql for NaiveTime

Available on crate feature chrono only.

fn to_sql(&self) -> Result<SqlValue, TypeError>

fn sql_type(&self) -> &'static str

impl ToSql for String

fn to_sql(&self) -> Result<SqlValue, TypeError>

fn sql_type(&self) -> &'static str

impl ToSql for Uuid

Available on crate feature uuid only.

fn to_sql(&self) -> Result<SqlValue, TypeError>

fn sql_type(&self) -> &'static str

impl ToSql for Value

Available on crate feature json only.

fn to_sql(&self) -> Result<SqlValue, TypeError>

fn sql_type(&self) -> &'static str

impl ToSql for Vec<u8>

fn to_sql(&self) -> Result<SqlValue, TypeError>

fn sql_type(&self) -> &'static str

impl ToSql for [u8]

fn to_sql(&self) -> Result<SqlValue, TypeError>

fn sql_type(&self) -> &'static str

impl ToSql for bool

fn to_sql(&self) -> Result<SqlValue, TypeError>

fn sql_type(&self) -> &'static str

impl ToSql for f32

fn to_sql(&self) -> Result<SqlValue, TypeError>

fn sql_type(&self) -> &'static str

impl ToSql for f64

fn to_sql(&self) -> Result<SqlValue, TypeError>

fn sql_type(&self) -> &'static str

impl ToSql for i16

fn to_sql(&self) -> Result<SqlValue, TypeError>

fn sql_type(&self) -> &'static str

impl ToSql for i32

fn to_sql(&self) -> Result<SqlValue, TypeError>

fn sql_type(&self) -> &'static str

impl ToSql for i64

fn to_sql(&self) -> Result<SqlValue, TypeError>

fn sql_type(&self) -> &'static str

impl ToSql for str

fn to_sql(&self) -> Result<SqlValue, TypeError>

fn sql_type(&self) -> &'static str

impl ToSql for u8

fn to_sql(&self) -> Result<SqlValue, TypeError>

fn sql_type(&self) -> &'static str

impl<T: ToSql + ?Sized> ToSql for &T

fn to_sql(&self) -> Result<SqlValue, TypeError>

fn sql_type(&self) -> &'static str

fn encrypted_param_type(&self) -> Option<EncryptedParamType>

impl<T: ToSql> ToSql for Option<T>

fn to_sql(&self) -> Result<SqlValue, TypeError>

fn sql_type(&self) -> &'static str

fn encrypted_param_type(&self) -> Option<EncryptedParamType>

Implementors

impl ToSql for Binary

impl ToSql for Char

impl ToSql for DateTime2

Available on crate feature chrono only.

impl ToSql for DateTimeLegacy

Available on crate feature chrono only.

impl ToSql for DateTimeOffset

Available on crate feature chrono only.

impl ToSql for Money

Available on crate feature decimal only.

impl ToSql for NChar

impl ToSql for Numeric

Available on crate feature decimal only.

impl ToSql for SmallDateTime

Available on crate feature chrono only.

impl ToSql for SmallMoney

Available on crate feature decimal only.

impl ToSql for Time

Available on crate feature chrono only.

impl ToSql for TypedNull