CompatibilityPreDistinctCollation
Synopsis
[SQL] CompatibilityPreDistinctCollation=n
n is either 1 or 0. The default value is 0.
Description
CompatibilityPreDistinctCollation is used to enable legacy DISTINCT/GROUP BY collation behavior.
CompatibilityPreDistinctCollation should only be enabled to preserve legacy DISTINCT/GROUP BY collation behavior for compatibility purposes. Otherwise CompatibilityPreDistinctCollation should remain disabled (its default value).
Changing This Parameter
To set the desired value for CompatibilityPreDistinctCollation from the Terminal, use the SetOption(“CompatibilityPreDistinctCollation”)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 change CompatibilityPreDistinctCollation 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).