Hello All. Currently Firebird uses rule "CHAR(X)+CHAR(Y)=>CHAR(MAX(X,Y))".Theoretically it can be changed into "CHAR(X)+CHAR(Y)=>CHAR(X) if X==Y and CHAR(X)+CHAR(Y)=>VARCHAR(MAX(X,Y)) if X!=Y".
But what SQL standard says about it?
-- WBR, SD. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel