Enum hdbconnect::HdbValue

pub enum HdbValue {
    NOTHING,
    TINYINT(u8),
    SMALLINT(i16),
    INT(i32),
    BIGINT(i64),
    DECIMAL(HdbDecimal),
    REAL(f32),
    DOUBLE(f64),
    CHAR(String),
    VARCHAR(String),
    NCHAR(String),
    NVARCHAR(String),
    BINARY(Vec<u8>),
    VARBINARY(Vec<u8>),
    CLOB(CLOB),
    NCLOB(CLOB),
    BLOB(BLOB),
    BOOLEAN(bool),
    STRING(String),
    NSTRING(String),
    BSTRING(Vec<u8>),
    TEXT(String),
    SHORTTEXT(String),
    LONGDATE(LongDate),
    N_TINYINT(Option<u8>),
    N_SMALLINT(Option<i16>),
    N_INT(Option<i32>),
    N_BIGINT(Option<i64>),
    N_DECIMAL(Option<HdbDecimal>),
    N_REAL(Option<f32>),
    N_DOUBLE(Option<f64>),
    N_CHAR(Option<String>),
    N_VARCHAR(Option<String>),
    N_NCHAR(Option<String>),
    N_NVARCHAR(Option<String>),
    N_BINARY(Option<Vec<u8>>),
    N_VARBINARY(Option<Vec<u8>>),
    N_CLOB(Option<CLOB>),
    N_NCLOB(Option<CLOB>),
    N_BLOB(Option<BLOB>),
    N_BOOLEAN(Option<bool>),
    N_STRING(Option<String>),
    N_NSTRING(Option<String>),
    N_BSTRING(Option<Vec<u8>>),
    N_TEXT(Option<String>),
    N_SHORTTEXT(Option<String>),
    N_LONGDATE(Option<LongDate>),
}

Enum for all supported database value types.

Variants

NOTHING

Internally swapped in where a real value is swapped out

TINYINT(u8)

TINYINT stores an 8-bit unsigned integer. The minimum value is 0. The maximum value is 255.

SMALLINT(i16)

SMALLINT stores a 16-bit signed integer. The minimum value is -32,768. The maximum value is 32,767.

INT(i32)

INT stores a 32-bit signed integer. The minimum value is -2,147,483,648. The maximum value is 2,147,483,647.

BIGINT(i64)

BIGINT stores a 64-bit signed integer. The minimum value is -9,223,372,036,854,775,808. The maximum value is 9,223,372,036,854,775,807.

DECIMAL(HdbDecimal)

DECIMAL(p, s) is the SQL standard notation for fixed-point decimal. "p" specifies precision or the number of total digits (the sum of whole digits and fractional digits). "s" denotes scale or the number of fractional digits. If a column is defined as DECIMAL(5, 4) for example, the numbers 3.14, 3.1415, 3.141592 are stored in the column as 3.1400, 3.1415, 3.1415, retaining the specified precision(5) and scale(4).

Precision p, can range from 1 to 38. The scale can range from 0 to p. If the scale is not specified, it defaults to 0. If precision and scale are not specified, DECIMAL becomes a floating-point decimal number. In this case, precision and scale can vary within the range 1 to 34 for precision and -6,111 to 6,176 for scale, depending on the stored value.

Examples: 0.0000001234 (1234E-10) has precision 4 and scale 10. 1.0000001234 (10000001234E-10) has precision 11 and scale 10. The value 1234000000 (1234E6) has precision 4 and scale -6.

REAL(f32)

REAL stores a single-precision 32-bit floating-point number.

DOUBLE(f64)

DOUBLE stores a double-precision 64-bit floating-point number. The minimum value is -1.7976931348623157E308, the maximum value is 1.7976931348623157E308 . The smallest positive DOUBLE value is 2.2250738585072014E-308 and the largest negative DOUBLE value is -2.2250738585072014E-308.

CHAR(String)

Fixed-length character String, only ASCII-7 allowed.

VARCHAR(String)

The VARCHAR(n) data type specifies a variable-length character string, where n indicates the maximum length in bytes and is an integer between 1 and 5000. If the VARCHAR(n) data type is used in a DML query, for example CAST (A as VARCHAR(n)), indicates the maximum length of the string in characters. SAP recommends using VARCHAR with ASCII characters based strings only. For data containing other characters, SAP recommends using the NVARCHAR data type instead.

NCHAR(String)

Fixed-length character string.

NVARCHAR(String)

The NVARCHAR(n) data type specifies a variable-length Unicode character set string, where indicates the maximum length in characters and is an integer between 1 and 5000.

BINARY(Vec<u8>)

The BINARY(n) data type is used to store binary data of a specified length in bytes, where n indicates the fixed length and is an integer between 1 and 5000.

VARBINARY(Vec<u8>)

The VARBINARY(n) data type is used to store binary data of a specified maximum length in bytes, where n indicates the maximum length and is an integer between 1 and 5000.

CLOB(CLOB)

The CLOB data type is used to store a large ASCII character string.

NCLOB(CLOB)

The NCLOB data type is used to store a large Unicode string.

BLOB(BLOB)

The BLOB data type is used to store a large binary string.

BOOLEAN(bool)

BOOLEAN stores boolean values, which are TRUE or FALSE.

STRING(String)

The DB returns all Strings as type STRING, independent of the concrete column type.

NSTRING(String)

Likely not used?

BSTRING(Vec<u8>)

The DB returns all binary values as type BSTRING.

TEXT(String)

The TEXT data type enables text search features. This data type can be defined for column tables, but not for row tables. This is not a standalone SQL-Type. Selecting a TEXT column yields a column of type NCLOB.

SHORTTEXT(String)

Similar to TEXT.

LONGDATE(LongDate)

Timestamp, uses eight bytes.

N_TINYINT(Option<u8>)

Nullable variant of TINYINT.

N_SMALLINT(Option<i16>)

Nullable variant of SMALLINT.

N_INT(Option<i32>)

Nullable variant of INT.

N_BIGINT(Option<i64>)

Nullable variant of BIGINT.

N_DECIMAL(Option<HdbDecimal>)

Nullable variant of DECIMAL

N_REAL(Option<f32>)

Nullable variant of REAL.

N_DOUBLE(Option<f64>)

Nullable variant of DOUBLE.

N_CHAR(Option<String>)

Nullable variant of CHAR.

N_VARCHAR(Option<String>)

Nullable variant of VARCHAR.

N_NCHAR(Option<String>)

Nullable variant of NCHAR.

N_NVARCHAR(Option<String>)

Nullable variant of NVARCHAR.

N_BINARY(Option<Vec<u8>>)

Nullable variant of BINARY.

N_VARBINARY(Option<Vec<u8>>)

Nullable variant of VARBINARY.

N_CLOB(Option<CLOB>)

Nullable variant of CLOB.

N_NCLOB(Option<CLOB>)

Nullable variant of NCLOB.

N_BLOB(Option<BLOB>)

Nullable variant of BLOB.

N_BOOLEAN(Option<bool>)

Nullable variant of BOOLEAN.

N_STRING(Option<String>)

Nullable variant of STRING.

N_NSTRING(Option<String>)

Nullable variant of NSTRING.

N_BSTRING(Option<Vec<u8>>)

Nullable variant of BSTRING.

N_TEXT(Option<String>)

Nullable variant of TEXT.

N_SHORTTEXT(Option<String>)

Nullable variant of SHORTTEXT.

N_LONGDATE(Option<LongDate>)

Nullable variant of LONGDATE.

Methods

impl TypedValue

fn try_into<'x, T: Deserialize<'x>>(self) -> Result<T, HdbError>

Deserialize into a rust type

Trait Implementations

impl DbValue for TypedValue

fn is_null(&self) -> bool

Returns true if this is a NULL value.

fn into_typed<'de, T>(self) -> Result<T, DeserializationError> where
    T: Deserialize<'de>, 

Converts the DbValue into a plain rust value.

impl DbValueInto<bool> for TypedValue

fn try_into(self) -> Result<bool, ConversionError>

Tries to convert into type T.

impl DbValueInto<u8> for TypedValue

fn try_into(self) -> Result<u8, ConversionError>

Tries to convert into type T.

impl DbValueInto<u16> for TypedValue

fn try_into(self) -> Result<u16, ConversionError>

Tries to convert into type T.

impl DbValueInto<u32> for TypedValue

fn try_into(self) -> Result<u32, ConversionError>

Tries to convert into type T.

impl DbValueInto<u64> for TypedValue

fn try_into(self) -> Result<u64, ConversionError>

Tries to convert into type T.

impl DbValueInto<i8> for TypedValue

fn try_into(self) -> Result<i8, ConversionError>

Tries to convert into type T.

impl DbValueInto<i16> for TypedValue

fn try_into(self) -> Result<i16, ConversionError>

Tries to convert into type T.

impl DbValueInto<i32> for TypedValue

fn try_into(self) -> Result<i32, ConversionError>

Tries to convert into type T.

impl DbValueInto<i64> for TypedValue

fn try_into(self) -> Result<i64, ConversionError>

Tries to convert into type T.

impl DbValueInto<f32> for TypedValue

fn try_into(self) -> Result<f32, ConversionError>

Tries to convert into type T.

impl DbValueInto<f64> for TypedValue

fn try_into(self) -> Result<f64, ConversionError>

Tries to convert into type T.

impl DbValueInto<String> for TypedValue

fn try_into(self) -> Result<String, ConversionError>

Tries to convert into type T.

impl DbValueInto<NaiveDateTime> for TypedValue

fn try_into(self) -> Result<NaiveDateTime, ConversionError>

Tries to convert into type T.

impl DbValueInto<Vec<u8>> for TypedValue

fn try_into(self) -> Result<Vec<u8>, ConversionError>

Tries to convert into type T.

impl Clone for TypedValue

fn clone(&self) -> TypedValue

Returns a copy of the value.

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

Performs copy-assignment from source.

impl Debug for TypedValue

fn fmt(&self, __arg_0: &mut Formatter) -> Result

Formats the value using the given formatter.

impl Display for TypedValue

fn fmt(&self, fmt: &mut Formatter) -> Result

Formats the value using the given formatter.