Hi!


I've just started 'hacking' at using FireBird 2.5.


I've been able to create the .fb database.


I've written my DDL script to populate the created database - and I
keep getting the a/m annoying message - apparently in the CREATE TABLE
script. Line 7 is the definition for my column "_Emails" - character
47 is in the middle of 'SIZE 255' and 'CHARACTER SET ASCII' tokens.
This location for such an error is crazy!


Everything seems to be properly formed - can anyone cast some light on
what I am missing here?


My script is:


CREATE TABLE "Administrators" (
"_Id" INTEGER NOT NULL,
"_MyDetailId" INTEGER DEFAULT 0,
"_Name" VARCHAR(50),
"_Designation" VARCHAR(50),
"_Address" BLOB SUB_TYPE TEXT SEGMENT SIZE 255 CHARACTER SET ASCII,
"_Emails" BLOB SUB_TYPE TEXT SEGMENT SIZE 255 CHARACTER SET ASCII,
"_TelephoneNumbers" BLOB SUB_TYPE TEXT SEGMENT SIZE 255 CHARACTER SET ASCII,
"_Reference" VARCHAR(50)
);


ALTER TABLE "Administrators" ADD CONSTRAINT "PrimaryKey" PRIMARY KEY ("_Id");
CREATE INDEX "_Id" ON "Administrators"("_Id");
CREATE INDEX "_MyDetailId" ON "Administrators"("_MyDetailId");


CREATE GENERATOR "GEN_Administrators__Id";


CREATE TRIGGER "TR_AI_Administrators__Id" FOR "Administrators"
ACTIVE BEFORE INSERT
POSITION 0
AS
BEGIN
IF (NEW."_Id" IS NULL) THEN
NEW."_Id" = GEN_ID("GEN_Administrators__Id", 1);
END;


------------------------cut------------------------


I look forward to any guidance...


Sincerely,


Arnold.