The "DataType" command describes data type of the field.
Syntax:
DataType Code="<data type code>" Name="<data type name>" [Length="<length>"] [Null="0|1"]
The '0' value means 'no null' when '1' means 'null allowed'.
The acceptable data type codes are:
- -7 is 'bit'
- -6 is 'tinyint'
- -5 is 'bigint' ('int8' for PostgreSQL)
- -4 is 'longvarbinary' ('image' for SQL server or 'blob' for Oracle, Interbase and DB2)
- -3 is 'varbinary'
- -2 id 'binary'
- -1 is 'lognvarchar' ('text' for SQL Server and PostgreSQL, 'clob' for Oracle and DB2)
- 1 is 'char'
- 2 is 'numeric'
- 3 is 'decimal' ('number' for Oracle)
- 4 is 'integer'
- 5 is 'smallint' ('int2' for PostgreSQL)
- 6 is 'float' ('float4' for PostgreSQL)
- 7 is 'real'
- 8 is 'double' ('double precision' for Oracle, 'float8' for PostgreSQL)
- 9 is 'datetime' or 'date'
- 10 is 'time'
- 11 is 'timestamp'
- 12 is 'varchar' ('varchar2' for Oracle)
Please contact our support team if your data type is not in this list.