Limitation when using ODBC

When binding values using ODBC, a limitation exists because ODBC cannot determine the data type of the column to which the value is being bound at the time the SQL statement is executed. Therefore, the data type of the value being passed must be explicitly specified. Because of this ODBC limitation, the ODBC Adapter determines the data type of the value according to the following rule:

If the value contains only numeric characters or numeric characters with a decimal point, the value is assumed to be numeric. Otherwise, the value is assumed to be text.

This rule provides the expected results in most cases. However, there might be some situations in which the rule might not apply and it might be necessary to specify the exact data type. For example, if the value is a text field consisting solely of numeric characters, the value is incorrectly interpreted as numeric unless correctly specified.