Filed Data Type

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.