Announcement: You can find the guides for Commerce 7.5 and later on the new Elastic Path Documentation site. The Developer Center continues to support Commerce 6.13.0 through 7.4.1.Visit new site

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')