Solid Toolbar


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   *        

 

Home

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