Issues surrounding Oracle instantclient 12.1

System environment: Windows server 2016.

Detailed:

The database environment used by the server is oracle 12 c. When the client want to insert some data into the server database, different versions of oracle instantclient will lead to different results.

If we use oracle instantclient 12.1.0.2, and try to insert the data type ‘date’ and ‘timestamp’ through the ODBC Driver，it cannot be inserted into server. But if we use the oracle instantclient 11.2.0.1 and insert the same data type, it can be inserted successfully.

For example, through the following program, we will use the statement to select respectively insert data with oracle instantclient 12.1.0.2 or oracle instantclient 11.2.0.1.