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

This version of Elastic Path Commerce is no longer supported or maintained. To upgrade to the latest version, contact your Elastic Path representative.

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