Skip to main content

OutSystems Language

 

OutSystems

Database Data Types

The following table represents how OutSystems data types are mapped to the data types of the database being used.

OutSystems SQL Server / SQL Azure Oracle MySQL Obs.
Text nvarchar(<length>) if the length is less than or equal to 2000, NVarchar(max) otherwise. VARCHAR2(<length>), if the length is less than or equal to 2000, CLOB otherwise. VARCHAR(<length>), if the length is less than or equal to 2000, LONGTEXT otherwise.
Integer int If an attribute with this type is set to auto number, the IDENTITY attribute is added. NUMBER(10) If an attribute with this type is set to auto number, a sequence is added. INT(11) If an attribute with this type is set to auto number, the AUTO_INCREMENT attribute is added.
Long Integer bigint If an attribute with this type is set to auto number, the IDENTITY attribute is added. NUMBER(20) If an attribute with this type is set to auto number, a sequence is added. BIGINT(20) If an attribute with this type is set to auto number, the AUTO_INCREMENT attribute is added.
Decimal decimal() The precision and scale values, are the ones defined by the Length and Decimals properties of the attribute. NUMBER() The precision and scale values, are the ones defined by the Length and Decimals properties of the attribute. DECIMAL() The precision and scale values, are the ones defined by the Length and Decimals properties of the attribute. At runtime, when values are read from (or saved to) the database, the number of decimal digits depends on the stack of the application server. Consider the restrictions of the System.Decimal in .NET, and those of the java.math.BigDecimal in Java.
Boolean bit NUMBER(1) TINYINT(1)
Date Time datetime TIMESTAMP DATETIME()
Date datetime TIMESTAMP DATETIME() Dates in OutSystems range from 1900-01-01 00:00:00 to 3000-12-31 23:59:59.
Time datetime TIMESTAMP DATETIME()
Phone Number varchar(20) VARCHAR2(20) VARCHAR(20)
Email varchar(250) VARCHAR2(250) VARCHAR(250)
Binary Data image BLOB BLOB
Currency decimal(37,8) NUMBER(37,8) DECIMAL(37,8) Entity Identifier
  • Was this article helpful?