Database datatypes

Beginning in WHD 12.0, the application only supports the following database software:

• Microsoft SQL Server (external database)
• MySQL (external database)
• PostgreSQL (embedded database)

If you are running a version prior to WHD 12.0, see Upgrade WHD for details about upgrading your WHD software and database.

The following table provides a reference for mapping data types from other databases to PostgreSQL (and to each other).

WHD	FrontBase	Oracle	Open Base	Postgre SQL	MySQL	SQL Server
PK	INTEGER	NUMBER	int	int4	INT	int
currency	DECIMAL	NUMBER	money	numeric	DECIMAL	money
datetime	TIMESTAMP	DATE	datetime	timestamptz	DATETIME	datetime
integer	INTEGER	NUMBER	int	int4	INT	int
pk	BLOB	BLOB	object	bytea	BLOB	varbinary(max)
data	BLOB	BLOB	object	bytea	LONGBLOB	varbinary(max)
text	VARCHAR 1000000	CLOB	char4000	text	TEXT	nvarchar(max)
varchar	VARCHAR	VARCHAR2	char	varchar	VARCHAR	nvarchar