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 ;;