DBPROP_MSMD_COMPARECASENOTSENSITIVESTRINGFLAGS Property

Adjusts case-insensitive string comparisons for a specified locale.

Remarks

This property’s name, which is used in the connection string, is CompareCaseNotSensitiveStringFlags.

Flags specified for this property are used in case-insensitive string comparisons. These flags control string comparisons and sort order. This property is used more frequently in some non-English versions such as Japanese. The default is the value of the CompareCaseNotSensitiveStringFlags registry on the client if this registry exists.

The client can modify case-insensitive string comparisons by setting the DBPROP_MSMD_COMPARECASENOTSENSITIVESTRINGFLAGS property. PivotTable® Service can have only one value for this property per Microsoft® Windows® process.

When multiple connections are opened in the same process, all connections will succeed as long as the result of applying case-insensitive string comparisons in all subsequent connections is equivalent to those established by the first connection.

It is an error for a subsequent connection to set the property to a value that would be different from that established by the first connection. This includes the scenario in which a first client sets a non-default value, and a second client does not set any value, expecting to use the default. It is the client application’s responsibility to manage these settings in a multiple-session per process scenario.

This property’s value is used when a session is established, but the value cannot be changed during the session.

(c) 1988-1998 Microsoft Corporation. All Rights Reserved.