Export (0) Print
Expand All

IDbCollationProperties.GetCollationProperties Method

Returns the collation properties used for a connection.

Namespace:  Microsoft.ReportingServices.DataProcessing
Assemblies:   Microsoft.ReportingServices.Interfaces (in Microsoft.ReportingServices.Interfaces.dll)
  Microsoft.ReportingServices.SharePoint.UI.WebParts (in Microsoft.ReportingServices.SharePoint.UI.WebParts.dll)

bool GetCollationProperties(
	out string cultureName,
	out bool caseSensitive,
	out bool accentSensitive,
	out bool kanatypeSensitive,
	out bool widthSensitive
)

Parameters

cultureName
Type: String
The name of the culture to use for collation.
caseSensitive
Type: Boolean
Indicates that the collation should be case sensitive.
accentSensitive
Type: Boolean
Indicates that the collation should be accent sensitive.
kanatypeSensitive
Type: Boolean
Indicates that the collation should be kana type sensitive.
widthSensitive
Type: Boolean
Indicates that the collation should be width sensitive.

Return Value

Type: Boolean
Returns true if the collation properties could be detected for the current connection.

This method returns the collation properties used for a connection. These property values can be used in reports which request auto-detected collation properties.

A data processing extension needs to execute one or more queries against a data source in order to determine the default collation properties. In order to execute queries from within the data extension, transactions need to be taken into account. For some managed data providers, the transaction property on a command must be explicitly set if the connection is in a transaction, even if the command was created using CreateCommand. To do this, you must cache the transaction when BeginTransaction is called, and release the transaction on Commit or Rollback.

Community Additions

ADD
Show:
© 2015 Microsoft