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 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).