DisableNLSCollationMismatchLogging
Synopsis
[SQL] DisableNLSCollationMismatchLogging=n
n is either 1 or 0. The default value is 0.
Description
When DisableNLSCollationMismatchLogging is enabled (n=1) InterSystems IRIS® data platform will disable the logging of warning messages to the messages.log file when the SQL engine encounters a mismatch between the NLS collations of the globals involved in a given query. Therefore, InterSystems IRIS will not log messages to messages.log for such a mismatch. However, the query plan always notes NLS collation mismatches, even if logging of these mismatches to messages.log is disabled; for information on viewing the query plan, see Viewing the Plan.
If DisableNLSCollationMismatchLogging is disabled (n=0), the logging of mismatched NLS collations is enabled; therefore InterSystems IRIS will log messages to messages.log for such a mismatch.
NLS collation mismatches can affect the validity of SQL query results.
It is not recommended to disable this mismatch logging.
Changing This Parameter
On the SQL page of the Management Portal (System Administration > Configuration > SQL and Object Settings > SQL), select the Disable the logging of global NLS collation mismatches during query compile to disable the NLS collation mismatch logging.
To set the desired value for DisableNLSCollationMismatchLogging from the Terminal, use the SetOption(“DisableNLSCollationMismatchLogging”)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 DisableNLSCollationMismatchLogging 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).
