Submitted by: @cincuranet

This script is failing.

/* SQL Manager 2005 Lite for InterBase/Firebird 4.4.0.5 */
/* ---------------------------------------------------- */
/* Host : localhost */
/* Database : D:\BASE.FDB */

/* Definition for the `NEW_TABLE_ID_GEN` generator : */

CREATE GENERATOR NEW_TABLE_ID_GEN;

SET GENERATOR NEW_TABLE_ID_GEN TO 2;

/* Structure for the `NEW_TABLE` table : */

CREATE TABLE NEW_TABLE (
ID INTEGER NOT NULL,
POPIS VARCHAR(100) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UTF8);

ALTER TABLE NEW_TABLE ADD PRIMARY KEY (ID);

/* Data for the `NEW_TABLE` table (Records 1 - 2) */

INSERT INTO NEW_TABLE
VALUES (1, 'benzím');

INSERT INTO NEW_TABLE
VALUES (2, 'elektřina');

COMMIT WORK;

/* Definition for the `BI_NEW_TABLE_ID` trigger : */

SET TERM ^ ;

CREATE TRIGGER BI_NEW_TABLE_ID FOR NEW_TABLE
ACTIVE BEFORE INSERT
POSITION 0
AS
BEGIN
IF (http://NEW.ID IS NULL) THEN
http://NEW.ID = GEN_ID(NEW_TABLE_ID_GEN, 1);
END^

SET TERM ; ^