SQL_TYPE

System.Data.Odbc.ODBC32.SQL_TYPE, System.Data underlying int16 System.Data

Values 29

Name	Value	Hex
CHAR		0x01
VARCHAR		0x0C
LONGVARCHAR		0xFFFFFFFFFFFFFFFF
WCHAR		0xFFFFFFFFFFFFFFF8
WVARCHAR		0xFFFFFFFFFFFFFFF7
WLONGVARCHAR		0xFFFFFFFFFFFFFFF6
DECIMAL		0x03
NUMERIC		0x02
SMALLINT		0x05
INTEGER		0x04
REAL		0x07
FLOAT		0x06
DOUBLE		0x08
BIT		0xFFFFFFFFFFFFFFF9
TINYINT		0xFFFFFFFFFFFFFFFA
BIGINT		0xFFFFFFFFFFFFFFFB
BINARY		0xFFFFFFFFFFFFFFFE
VARBINARY		0xFFFFFFFFFFFFFFFD
LONGVARBINARY		0xFFFFFFFFFFFFFFFC
TYPE_DATE		0x5B
TYPE_TIME		0x5C
TIMESTAMP		0x0B
TYPE_TIMESTAMP		0x5D
GUID		0xFFFFFFFFFFFFFFF5
SS_VARIANT		0xFFFFFFFFFFFFFF6A
SS_UDT		0xFFFFFFFFFFFFFF69
SS_XML		0xFFFFFFFFFFFFFF68
SS_UTCDATETIME		0xFFFFFFFFFFFFFF67
SS_TIME_EX		0xFFFFFFFFFFFFFF66

// System.Data.Odbc.ODBC32.SQL_TYPE, System.Data
enum class SQL_TYPE : int16
{
    CHAR = 1,
    VARCHAR = 12,
    LONGVARCHAR = -1,
    WCHAR = -8,
    WVARCHAR = -9,
    WLONGVARCHAR = -10,
    DECIMAL = 3,
    NUMERIC = 2,
    SMALLINT = 5,
    INTEGER = 4,
    REAL = 7,
    FLOAT = 6,
    DOUBLE = 8,
    BIT = -7,
    TINYINT = -6,
    BIGINT = -5,
    BINARY = -2,
    VARBINARY = -3,
    LONGVARBINARY = -4,
    TYPE_DATE = 91,
    TYPE_TIME = 92,
    TIMESTAMP = 11,
    TYPE_TIMESTAMP = 93,
    GUID = -11,
    SS_VARIANT = -150,
    SS_UDT = -151,
    SS_XML = -152,
    SS_UTCDATETIME = -153,
    SS_TIME_EX = -154,
};