Convert empty to null()

• Time: BEFORE
• Event: INSERT
• Source:

BEGIN
  IF (NEW.qualifier = '') OR (NEW.qualifier = 'NULL') THEN
    SET NEW.qualifier = NULL;
  END IF;
  IF (NEW.coll = '') OR (NEW.coll = 'NULL') THEN
    SET NEW.coll = NULL;
  END IF;
  IF (NEW.metaColl = '') OR (NEW.metaColl = 'NULL') THEN
    SET NEW.metaColl = NULL;
  END IF;
  IF (NEW.vial = '') OR (NEW.vial = 'NULL') THEN
    SET NEW.vial = NULL;
  END IF;
  IF (NEW.datum1 = '') OR (NEW.datum1 = 'NULL') THEN
    SET NEW.datum1 = NULL;
  END IF;
  IF (NEW.utmO = '') OR (NEW.utmO = 'NULL') THEN
    SET NEW.utmO = NULL;
  END IF;
  IF (NEW.utmN = '') OR (NEW.utmN = 'NULL') THEN
    SET NEW.utmN = NULL;
  END IF;
  IF (NEW.ffShort = '') OR (NEW.ffShort = 'NULL') THEN
    SET NEW.ffShort = NULL;
  END IF;
  IF (NEW.btListe = '') OR (NEW.btListe = 'NULL') THEN
    SET NEW.btListe = NULL;
  END IF;
  IF (NEW.subbiotop = '') OR (NEW.subbiotop = 'NULL') THEN
    SET NEW.subbiotop = NULL;
  END IF;
  IF (NEW.vid = '') OR (NEW.vid = 'NULL') THEN
    SET NEW.vid = NULL;
  END IF;
  IF (NEW.Bemerkung = '') OR (NEW.Bemerkung = 'NULL') THEN
    SET NEW.Bemerkung = NULL;
  END IF;
  IF (NEW.atlas = '') OR (NEW.atlas = 'NULL') THEN
    SET NEW.atlas = NULL;
  END IF;
  IF (NEW.AKHH = '') OR (NEW.AKHH = 'NULL') THEN
    SET NEW.AKHH = NULL;
  END IF;
  IF (NEW.ZMH = '') OR (NEW.qualifier = 'ZMH') THEN
    SET NEW.ZMH = NULL;
  END IF;
  IF (NEW.DBLokal = '') OR (NEW.DBLokal = 'NULL') THEN
    SET NEW.DBLokal = DATE_FORMAT(NOW(), '%d.%m.%Y');
  END IF;
  IF (NEW.SHMB = '') OR (NEW.SHMB = 'NULL') THEN
    SET NEW.SHMB = NULL;
  END IF;
  IF (NEW.methode = '') OR (NEW.methode = 'NULL') THEN
    SET NEW.qualifier = 'NN';
  END IF;
  IF (NEW.biotoptyp = '') OR (NEW.biotoptyp = 'NULL') THEN
    SET NEW.biotoptyp = 'NN';
  END IF;
  IF (NEW.biotop = '') OR (NEW.biotop = 'NULL') THEN
    SET NEW.biotop = 'NN';
  END IF;
END