Attribute

StringCollationMode (stcom)

Purpose

The string collation mode config option is used by the driver to determine how well the collation used by the Salesforce service for string columns matches the collation being used by the driver. When the collations match, then the driver assumes it is safe to push down requests that use the ordering of the columns. When the collations do not exactly match then the driver may still push down equality searches on the string columns but will not push down ordering operations. When the collations do not match at all, then the driver will not push down any operations using the string columns.

Valid Values

0 | 1 | 2

  • Match
  • CaseMatch
  • NoMatch

Behavior

Set the mode to 0 (Match) when the string collations are matching between the driver and the Salesforce service. Set the mode to 1 (CaseMatch) when the collations match to distinguish equality, but the ordering of values cannot be assumed to match. Set the mode to 2 (NoMatch) when the collations do not match and equality expressions cannot be used.

The default value for the driver is Match

Default Value

0 (Match)