Differences in supported databases data types

MVE supports Firebird and Microsoft SQL Server. The following table shows the Firebird data types used in MVE and their corresponding data types in Microsoft SQL Server.


Firebird data types	Microsoft SQL Server data types
BIGINT	Bigint
VARCHAR(x)	varchar(x)
TIMESTAMP	Datetime
INTEGER	Int
SMALLINT/ TINYINT^*	Bit
BLOB SUB_TYPE 0	varbinary(1024)

^*This data type is required for Microsoft SQL Server.