string_datatype

Usage

view: view_name {
  dimension: field_name {
    string_datatype: unicode
  }
}
Hierarchy
view
Field Type
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 ;;