For example:
CREATE TABLE SEC$USERS (
SEC$USER_NAME CHAR(63),
SEC$FIRST_NAME SEC$NAME_PART /* SEC$NAME_PART = VARCHAR(32) NOT NULL */,
SEC$MIDDLE_NAME SEC$NAME_PART /* SEC$NAME_PART = VARCHAR(32) NOT NULL */,
SEC$LAST_NAME SEC$NAME_PART /* SEC$NAME_PART = VARCHAR(32) NOT NULL */,
SEC$ACTIVE BOOLEAN,
SEC$ADMIN BOOLEAN,
SEC$DESCRIPTION BLOB SUB_TYPE 1 SEGMENT SIZE 80,
SEC$PLUGIN CHAR(63)
);
Why not VARCHAR?
Now all users of this fields must remove trailing spaces manually.
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
