The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.

Advantage Data Types Mapping

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

.NET Type Database Column Type
Boolean logical
Byte short
SByte short
Char nchar(1) or char(1)
Decimal money
Double double
Single double
Int16 short
UInt16 integer
Int32 integer
UInt32 money
Int64 numeric(20,0)
UInt64 numeric(21,0)
Guid char(36)
String nchar(N) or char(N)
DateTime timestamp
TimeSpan double
Byte[] blob
Unlimited size string nmemo or memo
See Also