Attribute

CollateWithUTFValues (cwuv)

Purpose

This option is used to configure the collation used by the drivers SQL engine. For optimal performance and query correctness, it is important to have the driver using the same collation as the Salesforce server.

Valid Values

0 | 1

true | false

Behavior

When set to true, the SQL engine collates string data by simply comparing unicode character values after upper casing the string. This approach is documented as the Salesforce server collation used in english locales.

When set to false, the SQL engine collates using an ICU collation based on the locale returned from Salesforce during the login.

The driver currently defaults this option to true.

Default Value

1 (true)