Oracle Data Types Mapping

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

.NET Type Database Column Type
Boolean number(1,0)
Byte number(3,0)
SByte number(3,0)
Char nchar
Decimal number(19,5)
Double double precision
Single float
Int16 number(5,0)
UInt16 number(5,0)
Int32 int
UInt32 numeric(10,0)
Int64 number(20,0)
UInt64 number(20,0)
Guid char(36)
String nvarchar2
DateTime date
TimeSpan double precision
Byte[] blob or raw(N)
Unlimited size string nclob
See Also