CompatibilityPreUnionCollation
Synopsis
[SQL] CompatibilityPreUnionCollation=n
n is either 1 or 0. The default value is 0.
Description
CompatibilityPreUnionCollation is used to enable legacy UNION collation behavior.
CompatibilityPreUnionCollation should only be enabled to preserve legacy UNION collation behavior for compatibility purposes. Otherwise CompatibilityPreUnionCollation should remain disabled (it’s default value).
When CompatibilityPreUnionCollation is disabled (n=0), the current UNION collation behavior is used. Where the default collation of the column (typically SQLUPPER) is applied to each value, similar to using an explicit DISTINCT clause.
When CompatibilityPreUnionCollation is enabled (n=1) the legacy UNION collation behavior is preserved. Where field values are taken as-is and the column is assumed to use EXACT collation for onward processing.
Change This Parameter
To set the desired value for CompatibilityPreUnionCollation from the Terminal, use the SetOption(“CompatibilityPreUnionCollation”)Opens in a new tab method of the %SYSTEM.SQL.UtilOpens in a new tab class. See the class reference for details.
You can also changeCompatibilityPreUnionCollation with the Config.SQLOpens in a new tab class (as described in the class reference) or by editing the CPF in a text editor (as described in Editing the Active CPF).
