Hi,
i agree with you totally. Because of something like this i have made wrong
assumption when i have created http://tracker.firebirdsql.org/browse/CORE-5807.
I never create char fields for variable length data. But FB developers can show
some light on this i suppose
Regards,Karol Bieniaszewski
-------- Oryginalna wiadomość --------Od: fbbt <d...@fastbase.net> Data:
28.04.2018 11:22 (GMT+01:00) Do: firebird-devel@lists.sourceforge.net Temat:
[Firebird-devel] CHAR fields in system tables
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
------------------------------------------------------------------------------
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
