Enum odbc_api::DataType

pub enum DataType {
    Unknown,
    Char {
        length: ULen,
    },
    Numeric {
        precision: ULen,
        scale: i16,
    },
    Decimal {
        precision: ULen,
        scale: i16,
    },
    Integer,
    SmallInt,
    Float,
    Real,
    Double,
    Varchar {
        length: ULen,
    },
    Date,
    Time {
        precision: i16,
    },
    Timestamp {
        precision: i16,
    },
    Bigint,
    Tinyint,
    Bit,
    Other {
        data_type: SqlDataType,
        column_size: ULen,
        decimal_digits: i16,
    },
}

Enumeration over valid SQL Data Types supported by ODBC

Variants

Unknown

The type is not known.

Char

Char(n). Character string of fixed length.

Fields of Char

length: ULen

Column size in characters (excluding terminating zero).

Numeric

`Numeric(p,s). Signed, exact, numeric value with a precision p and scale s (1 <= p <= 15; s <= p)

Fields of Numeric

precision: ULen

Total number of digits.

scale: i16

Number of decimal digits.

Decimal

Decimal(p,s). Signed, exact, numeric value with a precision of at least p and scale s. The maximum precision is driver-defined. (1 <= p <= 15; s <= p)

Fields of Decimal

precision: ULen

Total number of digits.

scale: i16

Number of decimal digits.

Integer

Integer. 32 Bit Integer

SmallInt

Smallint. 16 Bit Integer

Float

Float(p). Signed, approximate, numeric value with a binary precision of at least p. The maximum precision is driver-defined.

Depending on the implementation binary precision is either 24 (f32) or 53 (f64).

Real

Real. Signed, approximate, numeric value with a binary precision 24 (zero or absolute value 10[-38] to 10[38]).

Double

Double Precision. Signed, approximate, numeric value with a binary precision 53 (zero or absolute value 10[-308] to 10[308]).

Varchar

Varchar(n). Variable length character string.

Fields of Varchar

length: ULen

Maximum length of the character string (excluding terminating zero).

Date

Date. Year, month, and day fields, conforming to the rules of the Gregorian calendar.

Time

Time. Hour, minute, and second fields, with valid values for hours of 00 to 23, valid values for minutes of 00 to 59, and valid values for seconds of 00 to 61. Precision p indicates the seconds precision.

Fields of Time

precision: i16

Timestamp

Timestamp. Year, month, day, hour, minute, and second fields, with valid values as defined for the Date and Time variants.

Fields of Timestamp

precision: i16

Bigint

BIGINT. Exact numeric value with precision 19 (if signed) or 20 (if unsigned) and scale 0 (signed: -2[63] <= n <= 2[63] - 1, unsigned: 0 <= n <= 2[64] - 1). Has no corresponding type in SQL-92.

Tinyint

TINYINT. Exact numeric value with precision 3 and scale 0 (signed: -128 <= n <= 127, unsigned: 0 <= n <= 255)

Bit

BIT. Single bit binary data.

Other

The driver returned a type, but it is not among the other types of these enumeration. This is a catchall, in case the library is incomplete, or the data source supports custom or non-standard types.

Fields of Other

data_type: SqlDataType

Type of the column

column_size: ULen

Size of column element

decimal_digits: i16

Implementations

impl DataType

pub fn new(
    data_type: SqlDataType,
    column_size: ULen,
    decimal_digits: i16
) -> Self

This constructor is useful to create an instance of the enumeration using values returned by ODBC Api calls like SQLDescribeCol, rather than just initializing a variant directly.

pub fn data_type(&self) -> SqlDataType

The associated data_type discriminator for this variant.

pub fn column_size(&self) -> ULen

Return the column size, as it is required to bind the data type as a parameter.

pub fn decimal_digits(&self) -> i16

Return the number of decimal digits as required to bind the data type as a parameter.

Trait Implementations

impl Clone for DataType

fn clone(&self) -> DataType

Returns a copy of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Copy for DataType

impl Debug for DataType

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl Default for DataType

fn default() -> Self

Returns the "default value" for a type.

impl Eq for DataType

impl PartialEq<DataType> for DataType

fn eq(&self, other: &DataType) -> bool

This method tests for self and other values to be equal, and is used by ==.

fn ne(&self, other: &DataType) -> bool

This method tests for !=.

impl StructuralEq for DataType

impl StructuralPartialEq for DataType