Unofficial Content

The following table shows the corresponding empty value for each data type and DBMS.

DBMS Numeric Date DateTime Character (n) VarChar LongVarchar Blob
SQL Server 0 1753-01-01 00:00:00.000 1753-01-01 00:00:00.000 n blanks <empty string> <empty string> <empty file>
Oracle 0 0001-01-01 00:00:00 0001-01-01 00:00:00 n blanks 1 blank 1 blank <empty file>
DB2 UDB 0 0001-01-01 0001-01-01 00:00:00.000 n blanks <empty string> <empty string> <empty file>
DB2 iSeries 0 "00000000" or 0001-01-01(*) 0001-01-01-00.00.00 n blanks <empty string> <empty string> <empty file>
MySQL 0 1000-01-01 1000-01-01 00:00:00 <empty string> <empty string> <empty string> <empty file>
PostgreSQL 0 0001-01-01 0001-01-01 00:00:00 n blanks <empty string> <empty string> <empty file>
Informix 0 0001-01-01 0001-01-01 00:00:00 n blanks <empty string> <empty string> <empty file>

 

(*) For DB2 iSeries, the empty value depends on the "Date Data Type Definition" model property value.

See also

Handling Nulls with GeneXus

Last update: February 2024 | © GeneXus. All rights reserved. GeneXus Powered by Globant