Elastic Path Commerce Development

Database compatibility issues

Database compatibility issues

This page lists database compatibility issues and other database-specific considerations.

Oracle

Empty strings are considered null

Oracle considers the empty string ("") to be a null value. If you assign the empty string to a column that is set to not-null, the database operation will fail.

Ampersand (&) cannot be used in SQL scripts.

INSERT INTO TBRAND (UIDPK,CODE,GUID)
VALUES (1110,'D&H', 'D&H');

must be changed to the following.

INSERT INTO TBRAND (UIDPK,CODE,GUID)
VALUES (1110,concat('D', concat(CHR(38), 'H')),
        concat('D', concat(CHR(38), 'H')));

Literal date values must use the TO_DATE function

Literal date values like '2006-11-11 11:11:11' cannot be used in Oracle SQL scripts. Instead, the TO_DATE function must be used as shown below.

TO_DATE('2005-06-10','YYYY-MM-DD')