Share this page

# Data Types

Several VuGen functions, such as lrd_bind_col and Ird_bind_placeholder, require you to specify a data type. For additional information about data types, see the lrdtypes.h file supplied with VuGen. VuGen supports the following types:

Data Type | Code | Meaning
DT_VARRAW | 0x01 | Variable length binary
DT_VARCHAR | 0x02 | Variable length text
DT_RAW | 0x03 | Fixed-length binary
DT_SZ | 0x04 | Null-terminated variable-length string
DT_INT1 | 0x05 | 1-byte signed integer
DT_BIT | 0x06 | 1-byte unsigned integer
DT_INT2 | 0x07 | 2-byte signed integer
DT_INT4 | 0x08 | 4-byte signed integer
DT_NUMERIC | 0x09 | Numeric values
DT_DECIMAL | 0x0A | Decimal data (COBOL Comp-3)
DT_MONEY | 0x0B | Money representation
DT_DATETIME | 0x0C | Date and time representation
DT_FLT4 | 0x0D | 4-byte floating point number
DT_FLT8 | 0x0E | 8-byte floating point number
DT_MONEY4 | 0x0F | Money representation in short format
DT_DATETIME4 | 0x10 | Date and time in short format
DT_UINT1 | 0x14 | 1-byte unsigned integer
DT_UINT2 | 0x15 | 2-byte unsigned integer
DT_UINT4 | 0x16 | 4-byte unsigned integer
DT_SF | 0x17 | Fixed length string of character data
DT_SFZ | 0x18 | Fixed length null-terminated string
DT_VARNUM | 0x19 | Numeric values preceded by 1-byte length
DT_SF_STRIPPED_SPACES | 0x1A | Variable length string with trailing blank stripping
DT_LONG_CHAR | 0x1B | Long fixed length string
DT_LONG_RAW | 0x1C | Long fixed length binary data
DT_LONG_VARCHAR | 0x1D | Long variable length text
DT_LONG_VARRAW | 0x1E | Long variable length binary data
DT_DISPLAY | 0x1F | COBOL numeric character string
DT_ROWID | 0x20 | Unique ID of a database table row
DT_MLSLABEL | 0x21 | Operating system label
DT_SHORT_INT | 0x22 | Short signed integer
DT_INT | 0x23 | Signed integer
DT_LONG_INT | 0x24 | Signed long integer
DT_FLT | 0x25 | Single precision floating point
DT_DBL | 0x26 | Double precision floating point
ST_SZ_STRIPPED_SPACES | 0x27 | Null-terminated variable length string
DT_DATE | 0x28 | Date representation (no time)
DT_TIME_INTERVAL | 0x29 | Time interval
DT_LOCATOR | 0x2A | Locator
DT_FILE | 0x2B | File
DT_SFN | 0x2C | Null-padded fixed length character string
DT_SFNZ | 0x2D | Fixed length null-terminated character string
DT_TIME | 0x2E | Time representation (no date)
DT_SQL_DATE | 0x2F | Reserved - currently not in use
DT_SQL_TIME | 0x30 | Reserved - currently not in use
DT_SQL_TIMESTAMP | 0x31 | Reserved - currently not in use
DT_LONG_SZ | 0x32 | Null-terminated variable length string
DT_LONG_SFZ | 0x33 | Null-terminated fixed length string
DT_LONG_SFN | 0x35 | Null-padded fixed length character string
DT_CURSOR | 0x36 | Cursor
DT_SINT1 | 0x37 | 1-byte signed integer (SQL_C_STINYINT in ODBC)
DT_SINT2 | 0x38 | 2-byte signed integer (SQL_C_SSHORT in ODBC)
DT_SINT4 | 0x39 | 4-byte signed integer (SQL_C_SLONG in ODBC)
DT_CINT1 | 0x3A | 1-byte signed integer (SQL_C_TINYINT in ODBC)
DT_CINT2 | 0x3B | 2-byte signed integer (SQL_C_SHORT in ODBC)
DT_CINT4 | 0x3C | 4-byte signed integer (SQL_C_LONG in ODBC)
DT_FORCE_CINT1 | 0x3D | 1-byte signed integer (SQL_C_TINYINT in ODBC)
DT_FORCE_CINT2 | 0x3E | 2-byte signed integer (SQL_C_SHORT in ODBC)
DT_FORCE_CINT4 | 0x3F | 4-byte signed integer (SQL_C_LONG in ODBC)
DT_OCI_DATETIME | 0x40 | Date and time (SQLT_ODT in Oracle)
DT_OCI_CLOB | 0x41 | Character LOB descriptor (SQLT_CLOB in Oracle)
DT_OCI_BLOB | 0x42 | Binary LOB descriptor (SQLT_BLOB in Oracle)
DT_OCI_REFCURSOR | 0x43 | Reference cursor/ Result set (SQLT_RSET in Oracle)
DT_GUID | 0x44 | GUID structure (SQL_C_GUID in ODBC)
DT_OCI_ROWID | 0x45 | Unique handle ID of a database table row (SQLT_RDD in Oracle)

All the "FORCE" data types are for cases where the ODBC driver does not support the new signed type, SQL_C_Sxxx. In such a case, force it to use the old type - SQL_C_xxx.

Tips to improve your search results... VuGen Function Reference Version 26.1 Function Reference 26.1 All View Local Help Center View Online Help Center Version: