Firebird Data Types Mapping

XPO creates these column types when updating the Firebird database schema and expects them in existing databases.

.NET Type Database Column Type
Boolean char(1)
Byte numeric(3,0)
SByte numeric(3,0)
Char char
Decimal decimal(18,4)
Double double precision
Single float
Int16 smallint
UInt16 numeric(5,0)
Int32 integer
UInt32 numeric(10,0)
Int64 bigint
UInt64 numeric(18,0)
Guid char(36)
String char varying(N)
DateTime timestamp
TimeSpan double precision
Byte[] blob
Unlimited size string BLOB SUB_TYPE TEXT
See Also