Enum ColumnType 

#[non_exhaustive]
pub enum ColumnType {
    Char(Option<u32>),
    String(Option<u32>),
    Text,
    TinyInteger,
    SmallInteger,
    Integer,
    BigInteger,
    Float,
    Double,
    Decimal(Option<(u32, u32)>),
    Boolean,
    Date,
    Time,
    DateTime,
    Timestamp,
    TimestampWithTimeZone,
    Binary(Option<u32>),
    VarBinary(u32),
    Blob,
    Uuid,
    Json,
    JsonBinary,
    Array(Box<ColumnType>),
    Custom(String),
}

Available on crate feature database and non-WebAssembly only.

SQL column types

This enum represents the various column types supported across PostgreSQL, MySQL, and SQLite.

Variants (Non-exhaustive)

Non-exhaustive enums could have additional variants added in future. Therefore, when matching against variants of non-exhaustive enums, an extra wildcard arm must be added to account for any future variants.

Char(Option<u32>)

CHAR(n) - Fixed-length character string

String(Option<u32>)

VARCHAR(n) - Variable-length character string

Text

TEXT - Variable-length text

TinyInteger

TINYINT - Very small integer (1 byte)

SmallInteger

SMALLINT - Small integer (2 bytes)

Integer

INTEGER - Standard integer (4 bytes)

BigInteger

BIGINT - Large integer (8 bytes)

Float

FLOAT - Single precision floating point

Double

DOUBLE - Double precision floating point

Decimal(Option<(u32, u32)>)

DECIMAL(p, s) - Exact numeric with precision and scale

Boolean

BOOLEAN - Boolean value

Date

DATE - Date (year, month, day)

Time

TIME - Time of day

DateTime

DATETIME - Date and time (MySQL)

Timestamp

TIMESTAMP - Timestamp with timezone

TimestampWithTimeZone

TIMESTAMPTZ - Timestamp with timezone (PostgreSQL)

Binary(Option<u32>)

BINARY(n) - Fixed-length binary data

VarBinary(u32)

VARBINARY(n) - Variable-length binary data

Blob

BLOB - Binary large object

Uuid

UUID - Universally unique identifier

Json

JSON - JSON data

JsonBinary

JSONB - Binary JSON (PostgreSQL)

Array(Box<ColumnType>)

ARRAY - Array type (PostgreSQL)

Custom(String)

Custom type - for database-specific types

Security Note

Only use with trusted type names. Do not use with user input.

Trait Implementations

impl Clone for ColumnType

fn clone(&self) -> ColumnType

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for ColumnType

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

Formats the value using the given formatter.

impl PartialEq for ColumnType

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

Tests for self and other values to be equal, and is used by ==.

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

Tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl Eq for ColumnType

impl StructuralPartialEq for ColumnType