DataItem.Collation Property

 

Applies To: SQL Server 2016 Preview

Gets or sets the collation definition for the current DataItem.

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

Syntax

[TypeConverterAttribute("Microsoft.AnalysisServices.Design.CollationTypeConverter, Microsoft.AnalysisServices.Design")]
[XmlElementAttribute(IsNullable = false)]
[EditorAttribute("Microsoft.AnalysisServices.Design.CollationPropertyTypeEditor, Microsoft.AnalysisServices.Design", 
    typeof(UITypeEditor))]
public string Collation { get; set; }
public:
[TypeConverterAttribute("Microsoft.AnalysisServices.Design.CollationTypeConverter, Microsoft.AnalysisServices.Design")]
[XmlElementAttribute(IsNullable = false)]
[EditorAttribute("Microsoft.AnalysisServices.Design.CollationPropertyTypeEditor, Microsoft.AnalysisServices.Design", 
    (UITypeEditor^::typeid))]
property String^ Collation {
    String^ get();
    void set(String^ value);
}
[<TypeConverterAttribute("Microsoft.AnalysisServices.Design.CollationTypeConverter, Microsoft.AnalysisServices.Design")>]
[<XmlElementAttribute(IsNullable = false)>]
[<EditorAttribute("Microsoft.AnalysisServices.Design.CollationPropertyTypeEditor, Microsoft.AnalysisServices.Design",
    typeof(UITypeEditor))>]
member Collation : string with get, set
<TypeConverterAttribute("Microsoft.AnalysisServices.Design.CollationTypeConverter, Microsoft.AnalysisServices.Design")>
<XmlElementAttribute(IsNullable := False)>
<EditorAttribute("Microsoft.AnalysisServices.Design.CollationPropertyTypeEditor, Microsoft.AnalysisServices.Design",
    GetType(UITypeEditor))>
Public Property Collation As String

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)

See Also

DataItem Class
Microsoft.AnalysisServices Namespace

Return to top