This page is part of the book SQL-99 Complete, Really, by Peter Gulutzan & Trudy Pelzer. The authors have graciously allowed us to reproduce the contents of the book here. Because the book is about the SQL-99 standard, the contents of this and other pages in the book may not directly apply to MariaDB. Use the navigation bar to navigate the book.
Here are the type definitions in the
sqlcli.h header file. We use these
names for declarations of C variables in all our examples.
typedef unsigned char SQLCHAR; /* 8-bit-octet strings */ typedef long int SQLINTEGER; /* 32-bit, signed */ typedef short int SQLSMALLINT; /* 16-bit, signed */ typedef float SQLREAL; /* see heading: IEEE */ typedef double SQLDOUBLE; /* see heading: IEEE */ typedef void* SQLPOINTER; /* pointer, untyped */ typedef long int SQLHENV; /* 32-bit env handle */ typedef long int SQLHDBC; /* 32-bit dbc handle */ typedef long int SQLHSTMT; /* 32-bit hstmt handle */ typedef long int SQLHDESC; /* 32-bit desc handle */
Note: In the ODBC 3.0 header file,
SQLHDESC are all "
typedef void*" instead of "
typedef long int".
In older versions of the ODBC header file, the names were