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?