Pervasive Data Types Mapping

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

.NET Type Database Column Type
Boolean bit
Byte utinyint
SByte tinyint
Char varchar(4)
Decimal decimal(20,4)
Double double
Single real
Int16 smallint
UInt16 usmallint
Int32 integer
UInt32 uinteger
Int64 bigint
UInt64 ubigint
Guid char(36)
String varchar
DateTime timestamp
TimeSpan double
Byte[] longvarbinary
Unlimited size string longvarchar
See Also