Upgrading from previous versions
About this task
To upgrade from previous versions of Informix® OLE DB Provider, your database administrator must follow these steps:
Procedure
Results
Version 2.8 of Informix OLE DB Provider changes
the way some features used to operate in earlier versions. If you
have used a version before 2.8 of the Informix OLE DB Provider,
the issues you must be aware of are:
- OLE DB Provider handles the INTERVAL type differently in this
release. In versions before 2.8, interval data was returned as decimal
numbers with different sections of that number corresponding to year,
month, day, and other fields within the value. In order to interpret
the decimal number correctly. knowledge of the start and end fields
of the interval column was required .
In this release, the default type is a string with the format as described in the Informix Guide to SQL: Reference, with the provision that a conversion to a numeric type is also allowed. If a datetime interval is requested in DB_TYPE_I8 format, the number returned will have 1/100,000 seconds as the unit of measure.
- OLE DB Provider handles complex data types, collections, and row
types differently in this release. Data of these types is presented
in string format as LVARCHAR data. This method is similar to the method
that is used to interact with this data by using the DB-Access tool.
As an example of the format being presented, if a column has the definition:
my_date MULTISET(date not null)Data contained in this column is returned to the application in the format:MULTISET{'08/15/2000','02/02/2002','10/11/1999'} - Type handling for the DECIMAL, MONEY, and DATETIME types has changed from the previous release.