
SOLID Light Client
Type Conversion Matrix
The tables below describe the type conversions
provided by SOLID Light Client functions SQLGetCol and
SQLSetParamValue.
Abbreviations used in the tables for the C variable
data types are as follows:
Abbreviation |
API parameter definition |
C variable data types |
Bin |
SQL_C_BINARY |
void * |
Char |
SQL_C_CHAR |
char[], char * |
Long |
SQL_C_LONG |
long int (*) , 32 bits |
Short |
SQL_C_SHORT |
short int (*) , 16 bits |
Float |
SQL_C_FLOAT |
float (*) |
Double |
SQL_C_DOUBLE |
double (*) |
(*) NOTE that when variables of these data types are
used as parameters in Light Client function calls,
actually the pointer the variable must be passed instead.
For description of the SQL data types please refer to SOLID Server
Administrator's Guide, Appendix C Data Types.
Functions SQLGetCol and SQLGetData perform
the following data type conversions between database
column types and C variable data types:
SQL data type \ C variable data type |
Bin |
Char |
Long |
Short |
Float |
Double |
TINYINT |
* |
* |
* |
* |
* |
* |
LONG VARBINARY |
* |
* |
|
|
|
|
VARBINARY |
* |
* |
|
|
|
|
BINARY |
* |
* |
|
|
|
|
LONG VARCHAR |
* |
* |
|
|
|
|
CHAR |
* |
* |
|
|
|
|
NUMERIC |
|
* |
* |
* |
* |
* |
DECIMAL |
|
* |
* |
* |
* |
* |
INTEGER |
* |
* |
* |
* |
* |
* |
SMALLINT |
* |
* |
* |
* |
* |
* |
FLOAT |
* |
* |
* |
* |
* |
* |
REAL |
* |
* |
* |
* |
* |
* |
DOUBLE |
* |
* |
* |
* |
* |
* |
DATE |
|
* |
|
|
|
|
TIME |
|
* |
|
|
|
|
TIMESTAMP |
|
* |
|
|
|
|
VARCHAR |
* |
* |
|
|
|
|
Function SQLSetParamValue provides the
following type conversions between C data types and the
database column types
SQL data type \ C variable data type |
Bin |
Char |
Long |
Short |
Float |
Double |
TINYINT |
|
* |
* |
* |
|
|
LONG VARBINARY |
* |
|
|
|
|
|
VARBINARY |
* |
|
|
|
|
|
BINARY |
* |
|
|
|
|
|
LONG VARCHAR |
|
* |
|
|
|
|
CHAR |
|
* |
|
|
|
|
NUMERIC |
|
* |
* |
* |
* |
* |
DECIMAL |
|
* |
* |
* |
* |
* |
INTEGER |
|
* |
* |
* |
|
|
SMALLINT |
|
* |
* |
* |
|
|
FLOAT |
|
* |
* |
* |
* |
* |
REAL |
|
* |
* |
* |
* |
* |
DOUBLE |
|
* |
* |
* |
* |
* |
DATE |
|
* |
|
|
|
|
TIME |
|
* |
|
|
|
|
TIMESTAMP |
|
* |
|
|
|
|
VARCHAR |
|
* |
|
|
|
|

Company | Products | Support | Search | Free Eval Packs
Copyright © 1992-1997 Solid Information Technology Ltd.
All rights reserved.
|