EMPTY_BLOB Function - Oracle to MariaDB Migration

In Oracle, the EMPTY_BLOB function creates an empty BLOB locator i.e. an empty (with 0 length), but non-NULL BLOB value.

In MariaDB, you can use x'' constant (empty binary string).

Oracle:

  -- A sample table
  CREATE TABLE t1 (
    c1 BLOB DEFAULT EMPTY_BLOB()
  );

MariaDB:

  -- A sample table
  CREATE TABLE t1 (
    c1 LONGBLOB DEFAULT x''
  );