Specifications

96 Using Databases with ID Works Projects
ID Works Standard and Enterprise Version 5 Administrator’s Guide
ID Works fields of type Binary
1
, Photo, or Signature map to:
ID Works fields of type Date map to:
If the database’s date data type supports time, but a time mask is not
specified for the Production Form date field, a default time value
(typically 00:00:00) is assigned to each inserted date value. When
searching using a date, ID Works software searches for times
between 00:00:00 and 23:59:59 on that date.
Access data types BLOB: OLE Object
File: Text(255)
DB2 data types BLOB: Blob
File: Varchar(255)
Oracle data types BLOB: Long Raw, BLOB*
File: Varchar2(255)
* BLOB is supported if the Oracle 8i or greater ODBC driver or OLE
DB provider is used and configured appropriately. (See the Read
Me File for details on limitations.)
SQL Server data types BLOB: Image
File: Varchar(255)
1Binary fields are only available in ID Works Enterprise.
Access data type Date/Time
DB2 data types Date, Timestamp
Oracle data type Date
SQL Server data types Datetime, Small Datetime