This topic has not yet been rated - Rate this topic

DataItem.Collation Property

SQL Server 2012

Other Versions

Gets or sets the collation definition for the current DataItem.

Namespace: Microsoft.AnalysisServices
Assembly: Microsoft.AnalysisServices (in Microsoft.AnalysisServices.dll)

Syntax

C++

JScript

[TypeConverterAttribute("Microsoft.AnalysisServices.Design.CollationTypeConverter, Microsoft.AnalysisServices.Design")]
public string Collation { get; set; }

Property Value

Type: System.String
A System.String with the Locale Id, underscore (_), and character comparison definition flag.

Remarks

Collation definition is composed of Locale Id string and the character comparison definition flag.

Character comparison definition flags are described in the following table.

binary	_BIN
binary2	_BIN2
case sensitive	_CS
case insensitive	_CI
accent sensitive	_AS
accent insensitive	_AI
kana-sensitive	_KS
width-sensitive	_WS

For a detailed explanation about comparison flags, see Windows Collation Name (Transact-SQL)

Reference

DataItem Class

Microsoft.AnalysisServices Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD