Usage
view: view_name {
dimension: field_name {
string_datatype: unicode
}
}
dimension: field_name {
string_datatype: unicode
}
}
Hierarchystring_datatype |
Possible Field TypesDimensionAcceptsThe valueunicodeSpecial RulesApplies only to dimensions oftype: string (which is the default if no type is specified)
|
Definition
The string_datatype parameter lets you specify that the dimension’s string values are unicode characters, which is helpful for dialects requiring special filter handling. Specifically, you can specify string_datatype: unicode for Microsoft SQL Server and MySQL for fields that have filters with unicode characters. This applies to:
- Microsoft SQL Server (MSSQL) for non-Latin collations types
- MySQL for variable character (NVARCHAR) and fixed-number character (NCHAR) types
The string_datatype: unicode parameter applies only to dimensions of type: string (which is the default value for the type parameter).
Examples
dimension: comments {
string_datatype: unicode
sql: ${TABLE}.comments ;;
}