Skip to main content

 

OutSystems Language

 

 

OutSystems

Default Values on Database

  • Edit
    Collaborate with us
    Edit this page on GitHub
  • The following table represents the default values of the OutSystems data types, and the respective values stored in the database.

    Data Type OutSystems SQL Server Oracle MySQL
    Text "" (empty string) "" (empty string) " " (single space) "" (empty string)
    Integer 0 0 0 0
    Long Integer 0 0 0 0
    Decimal 0 0 0 0
    Boolean False 0 0 0
    Date Time 1900-01-01 00:00:00 1900-01-01 00:00:00 1900-01-01 00:00:00 1900-01-01 00:00:00
    Date 1900-01-01 1900-01-01 00:00:00 1900-01-01 00:00:00 1900-01-01 00:00:00
    Time 00:00:00 1900-01-01 00:00:00 1900-01-01 00:00:00 1900-01-01 00:00:00
    Phone Number "" (empty string) "" (empty string) " " (single space) "" (empty string)
    Email "" (empty string) "" (empty string) " " (single space) "" (empty string)
    Binary Data Byte array with no elements Byte array with no elements Byte array with no elements Byte array with no elements
    Currency 0 0 0 0
    Entity Identifier "" or 0 Null Null Null
    • Was this article helpful?