Skip to main content

 

 

 

 

Template:OutSystems/Documentation_KB/Breadcrumb_New_Layout

 

 

Template:OutSystems/OSLanguageSwitcher

 

 

 

OutSystems

Database Data Types

Template:OutSystems/Documentation_KB/ContentCollaboration
  • Edit
    Collaborate with us
    Edit this page on GitHub
  • 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 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.
    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.
    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.
    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. 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 System.Decimal.
    Boolean bit NUMBER(1)
    Date Time datetime TIMESTAMP
    Date datetime TIMESTAMP
    Time datetime TIMESTAMP
    Phone Number varchar(20) VARCHAR2(20)
    Email varchar(250) VARCHAR2(250)
    Binary Data image BLOB
    Currency decimal(37,8) NUMBER(37,8)
    Entity Identifier Depends on the type of the Identifier.
    • Was this article helpful?