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