Skip to main content

Reference

 

OutSystems

Mapping External DB Data Types to OutSystems Data Types

When connecting to external databases, OutSystems maps the external DB Data Types into OutSystems Data Types as follows:

SQL Server Oracle Data Type MySQL Data Type DB2 Data Type OutSystems Data Type
Char
Varchar
Text
Nchar
Nvarchar
Ntext
Xml
Decimal(Any,> 8)
Numeric(Any,> 8)
Real
Float
UniqueIdentifier
Time
Datetimeoffset
Char
Varchar
Varchar2
Clob
Long
Nchar
NVarchar2
Nclob
Number(Any,> 8)
Float
Binary_float
Binary_double
RowId
URowId
XmlType
Varchar
Char
Longtext
Mediumtext
Tinytext
Text
Enum
Set
Decimal(> 28,Any)
Decimal(Any,> 8)
Numeric(> 28,Any)
Numeric(Any,> 8)
Double
Real
Float
Time
Character
Varchar
Clob
DbClob
Xml
Decimal(> 28,Any)
Decimal(Any,> 8)
Numeric(> 28,Any)
Numeric(Any,> 8)
Float
Real
DecFloat
Double Float
Time
Nchar
Nvarchar
NClob
Text
Tinyint
Smallint
Int
Decimal(1-9,0)
Numeric(1-9,0)
Number(2-9,0) Tinyint(> 1)
Smallint
Mediumint
Int
Decimal(1-9,0)
Numeric(1-9,0)
Integer
Smallint
Decimal(1-9,0)
Numeric(1-9,0)
Integer
Bigint
Decimal(10-18,0)
Numeric(10-18,0)
Number(10-18,0) Bigint
Unsigned Int
Bit(2-64)
Decimal(10-18,0)
Numeric(10-18,0)
Bigint
Decimal(10-18,0)
Numeric(10-18,0)
Long Integer
Decimal(19-28,0-8)
Decimal(1-18,>1-8)
Numeric(19-28,0-8)
Numeric(1-18,>1-8)
Money
Smallmoney
Number(19-28,0-8)
Number(1-18,1-8)
Unsigned Bigint
Decimal(19-28,0-8)
Decimal(1-18,1-8)
Numeric(19-28,0-8)
Numeric(1-18,1-8)
Decimal(1-18,1-8)
Decimal(19-28,0-8)
Numeric(1-18,1-8)
Numeric(19-28,0-8)
Decimal
Bit Number(1,0) Bit(1)
Tinyint(1)
SmallInt*
Integer*
Bigint*

* with constraint in (0,1)
Boolean
Date   Date Date Date
Datetime
DateTime2
Smalldatetime
Date
Timestamp
Datetime
Timestamp
Timestamp DateTime
Image
Binary
Varbinary
Bfile
Blob
Raw
Long Raw
Blob
Longblob
Tinyblob
Mediumblob
Binary
Varbinary
Binary
Blob
Char(Bit)
VarChar(Bit)
VarBinary
Binary Data
Sql_variant
Geometry
HierarchyId
Geography
Rowversion
Timestamp
Interval day to second
Interval year to month
Polygon
Point
Multipoint
MultiPolygon
LineString
MultiLineString
Geometry
GeometryCollection
Year
Datalink
Graphic
Vargraphic
RowId
No mapping available.

The attribute will be marked as "Ignored" in Integration Studio.

For Decimal(M,D) or similar, M is the maximum number of digits (the precision) and D is the number of digits to the right of the decimal point (the scale).

  • Was this article helpful?