On 28-4-2018 13:10, Alex Peshkoff via Firebird-devel wrote:
On 04/28/18 12:22, fbbt wrote:
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.
That's how SQL identifiers traditionally look like in all system tables:
Sure, but is there any reason why this couldn't be changed with a new ODS?
--
Mark Rotteveel
------------------------------------------------------------------------------
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
