Usage
view: view_name { dimension: field_name { string_datatype: unicode } }
Hierarchy
string_datatype |
Possible Field Types
Dimension
Accepts
The value unicode
Special Rules
Applies only to dimensions of type: 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 ;;