description: If you try to set parameter values as a type different from a native data type for parameter - it may get interpreted as NULL.

for example query

select * from rdb$database where :a = '1'

if you set parameter :a as NULL integer value

This is due to broken conversion of ODBC indicator variables to XSQLDA equivalents during data type coercion in ODBC driver

=>

If you try to set parameter values as a type different from a native data type for parameter - it may get interpreted as NULL.

for example query

select * from rdb$database where :a = '1'

if you set parameter :a to 1 as integer, it will get interpreted as as NULL value and you get no result row

This is due to broken conversion of ODBC indicator variables to XSQLDA equivalents during data type coercion in ODBC driver

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

assignee: Nickolay Samofatov [ skidder ]

Fix Version: 2.1 Beta [ 10410 ]

Link: This issue duplicates ODBC140 [ ODBC140 ]

status: Resolved [ 5 ] => Closed [ 6 ]