The following table represents the OutSystems Platform default values, and the respective values stored in the database.

Data Type

OutSystems Platform

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

See Also

Database Data Types