IDbCollationProperties.GetCollationProperties Method
Returns the collation properties used for a connection.
Namespace: Microsoft.ReportingServices.DataProcessing
Assemblies: Microsoft.ReportingServices.SharePoint.UI.WebParts (in Microsoft.ReportingServices.SharePoint.UI.WebParts.dll)
Microsoft.ReportingServices.Interfaces (in Microsoft.ReportingServices.Interfaces.dll)
Syntax
'Declaration
Function GetCollationProperties ( _
<OutAttribute> ByRef cultureName As String, _
<OutAttribute> ByRef caseSensitive As Boolean, _
<OutAttribute> ByRef accentSensitive As Boolean, _
<OutAttribute> ByRef kanatypeSensitive As Boolean, _
<OutAttribute> ByRef widthSensitive As Boolean _
) As Boolean
'Usage
Dim instance As IDbCollationProperties
Dim cultureName As String
Dim caseSensitive As Boolean
Dim accentSensitive As Boolean
Dim kanatypeSensitive As Boolean
Dim widthSensitive As Boolean
Dim returnValue As Boolean
returnValue = instance.GetCollationProperties(cultureName, _
caseSensitive, accentSensitive, _
kanatypeSensitive, widthSensitive)
bool GetCollationProperties(
out string cultureName,
out bool caseSensitive,
out bool accentSensitive,
out bool kanatypeSensitive,
out bool widthSensitive
)
bool GetCollationProperties(
[OutAttribute] String^% cultureName,
[OutAttribute] bool% caseSensitive,
[OutAttribute] bool% accentSensitive,
[OutAttribute] bool% kanatypeSensitive,
[OutAttribute] bool% widthSensitive
)
abstract GetCollationProperties :
cultureName:string byref *
caseSensitive:bool byref *
accentSensitive:bool byref *
kanatypeSensitive:bool byref *
widthSensitive:bool byref -> bool
function GetCollationProperties(
cultureName : String,
caseSensitive : boolean,
accentSensitive : boolean,
kanatypeSensitive : boolean,
widthSensitive : boolean
) : boolean
Parameters
- cultureName
Type: System.String%
The name of the culture to use for collation.
- caseSensitive
Type: System.Boolean%
Indicates that the collation should be case sensitive.
- accentSensitive
Type: System.Boolean%
Indicates that the collation should be accent sensitive.
- kanatypeSensitive
Type: System.Boolean%
Indicates that the collation should be kana type sensitive.
- widthSensitive
Type: System.Boolean%
Indicates that the collation should be width sensitive.
Return Value
Type: System.Boolean
Returns true if the collation properties could be detected for the current connection.
Remarks
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.