Data Types
[C API]

Like most database systems, ITTIA DB™ allows constraints to be put on data stored in the database. More...


Data Structures

union  db_largeint_t
 Large integer (64-bit) data type. More...
union  db_ulargeint_t
 Unsigned large integer (64-bit) data type. More...
struct  db_date_t
 Date data type. More...
struct  db_time_t
 Time data type. More...
struct  db_datetime_t
 Date and time data type. More...
struct  db_timestamp_t
 Timestamp data type. More...
struct  db_blob_t
 BLOB access data type. More...

Defines

#define DB_COLTYPE_IS_UTFSTR(a)   (a == DB_COLTYPE_UTF8STR || a == DB_COLTYPE_UTF16STR || a == DB_COLTYPE_UTF32STR)

Typedefs

typedef struct db_coltype_t_s * db_coltype_t
typedef struct db_vartype_t_s * db_vartype_t

Data Types

typedef char db_ansi_t
typedef uint8_t db_utf8_t
typedef uint16_t db_utf16_t
typedef uint32_t db_utf32_t
typedef float32_t db_float32_t
typedef float64_t db_float64_t
typedef db_ssize_t db_len_t
typedef db_ssize_t db_fieldno_t
typedef void * db_object_t

Database Data Type Identifiers

#define DB_COLTYPE_SINT8   _DB_COLTYPE_SINT8
#define DB_COLTYPE_UINT8   _DB_COLTYPE_UINT8
#define DB_COLTYPE_SINT16   _DB_COLTYPE_SINT16
#define DB_COLTYPE_UINT16   _DB_COLTYPE_UINT16
#define DB_COLTYPE_SINT32   _DB_COLTYPE_SINT32
#define DB_COLTYPE_UINT32   _DB_COLTYPE_UINT32
#define DB_COLTYPE_SINT64   _DB_COLTYPE_SINT64
#define DB_COLTYPE_UINT64   _DB_COLTYPE_UINT64
#define DB_COLTYPE_FLOAT32   _DB_COLTYPE_FLOAT32
#define DB_COLTYPE_FLOAT64   _DB_COLTYPE_FLOAT64
#define DB_COLTYPE_CURRENCY   _DB_COLTYPE_CURRENCY
#define DB_COLTYPE_DATE   _DB_COLTYPE_DATE
#define DB_COLTYPE_TIME   _DB_COLTYPE_TIME
#define DB_COLTYPE_DATETIME   _DB_COLTYPE_DATETIME
#define DB_COLTYPE_TIMESTAMP   _DB_COLTYPE_TIMESTAMP
#define DB_COLTYPE_ANSISTR   _DB_COLTYPE_ANSISTR
#define DB_COLTYPE_UTF8STR   _DB_COLTYPE_UTF8STR
#define DB_COLTYPE_UTF16STR   _DB_COLTYPE_UTF16STR
#define DB_COLTYPE_UTF32STR   _DB_COLTYPE_UTF32STR
#define DB_COLTYPE_BLOB   _DB_COLTYPE_BLOB
#define DB_COLTYPE_UNDEFINED   _DB_COLTYPE_UNDEFINED
#define DB_COLTYPE_WCHARSTR   (sizeof(wchar_t) == sizeof(db_utf16_t) ? DB_COLTYPE_UTF16STR : DB_COLTYPE_UTF32STR)

C Language Data Type Identifiers

#define DB_VARTYPE_SINT8   _DB_VARTYPE_SINT8
#define DB_VARTYPE_UINT8   _DB_VARTYPE_UINT8
#define DB_VARTYPE_SINT16   _DB_VARTYPE_SINT16
#define DB_VARTYPE_UINT16   _DB_VARTYPE_UINT16
#define DB_VARTYPE_SINT32   _DB_VARTYPE_SINT32
#define DB_VARTYPE_UINT32   _DB_VARTYPE_UINT32
#define DB_VARTYPE_SINT64   _DB_VARTYPE_SINT64
#define DB_VARTYPE_UINT64   _DB_VARTYPE_UINT64
#define DB_VARTYPE_FLOAT32   _DB_VARTYPE_FLOAT32
#define DB_VARTYPE_FLOAT64   _DB_VARTYPE_FLOAT64
#define DB_VARTYPE_DATE   _DB_VARTYPE_DATE
#define DB_VARTYPE_TIME   _DB_VARTYPE_TIME
#define DB_VARTYPE_DATETIME   _DB_VARTYPE_DATETIME
#define DB_VARTYPE_TIMESTAMP   _DB_VARTYPE_TIMESTAMP
#define DB_VARTYPE_ODBC_DATE   _DB_VARTYPE_ODBC_DATE
#define DB_VARTYPE_ODBC_TIME   _DB_VARTYPE_ODBC_TIME
#define DB_VARTYPE_ODBC_TIMESTAMP   _DB_VARTYPE_ODBC_TIMESTAMP
#define DB_VARTYPE_ANSISTR   _DB_VARTYPE_ANSISTR
#define DB_VARTYPE_UTF8STR   _DB_VARTYPE_UTF8STR
#define DB_VARTYPE_UTF16STR   _DB_VARTYPE_UTF16STR
#define DB_VARTYPE_UTF32STR   _DB_VARTYPE_UTF32STR
#define DB_VARTYPE_BLOB   _DB_VARTYPE_BLOB
#define DB_VARTYPE_UNDEFINED   _DB_VARTYPE_UNDEFINED
#define DB_VARTYPE_WCHARSTR   (sizeof(wchar_t) == sizeof(db_utf16_t) ? DB_VARTYPE_UTF16STR : DB_VARTYPE_UTF32STR)

Detailed Description

Like most database systems, ITTIA DB™ allows constraints to be put on data stored in the database.

Each column in a table is restricted to contain only a specific type of data, such as a number or a string of text.


Copyright © 2005-2009 ITTIA®. All rights reserved.