Default Values in Database

The next table displays how the Service Studio default values are inserted in SQL Server and Oracle databases.

If you are using Foreign Entities with null value behavior the default values may be converted to effective null values when stored in the database. Check for further information in Integration Studio's documentation.

As you can confirm, in this situation, the values used are the null values defined for each data type, except the Text and Phone Number, which must be different in Oracle.

Service Studio data type	Service Studio default value	SQL Server value	Oracle value
Text	"" (empty string)	"" (empty string)	" " (single space)
Integer	0	0	0
Decimal	0	0	0
Boolean	False	0	0
Date Time	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
Time	00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00
Phone Number	"" (empty string)	"" (empty string)	" " (single space)
Binary Data	Byte array with no elements	Byte array with no elements	Byte array with no elements
Currency	0	0	0
Entity Identifier	"" or 0	Null	Null