Default data types for dynamically created tables The following table lists the hardcoded data types that the Interact runtime system uses by default for each supported database for float, number, date/time and string columns. Database Default data types DB2 float bigint timestamp varchar Informix float int8 DATETIME YEAR TO FRACTION char2 Oracle float number(19) timestamp varchar2 SQL Server float bigint datetime nvarchar
The following table lists the hardcoded data types that the Interact runtime system uses by default for each supported database for float, number, date/time and string columns.
