You can use the Silk Performer data types number, float and string to exchange values between a Silk Performer program and your DBMS. Silk Performer uses the following default data type mapping for Silk Performer data types, ODBC C data types, and ODBC SQL data types.
| Silk Performer data type | ODBC C data type | ODBC SQL data type |
|---|---|---|
| number | SQL_C_LONG | SQL_INTEGER |
| float | SQL_C_DOUBLE | SQL_FLOAT |
| string <= 254 | SQL_C_CHAR | SQL_CHAR |
| string > 254 | SQL_C_CHAR | SQL_LONGVARCHAR |
Silk Performer uses this mapping for binding input values into values with the ODBC functions SQLBindParameter and SQLBindCol.
You can use the Silk Performer data type number for associating with any numeric data types of your DBMS. The Silk Performer data type number represents integer values. Therefore floating-point values received from a DBMS data type like number, decimal, float or real are rounded to an integer value. To avoid this, you should bind numeric DBMS data types that are noninteger to the Silk Performer data type float.
You can use the Silk Performer data type string for associating with any numeric and non-numeric data type of your DBMS (for example., DATE data types). You need only assure that the values you want to exchange correspond to the type and length requirements of the Silk Performer and the DBMS data type. You can also associate any DBMS data type to the Silk Performer data buffer.