Skip to main content

Reference

 

OutSystems

Default Values on Database

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?