home User Guide Getting Started Help Center Documentation Community Training Certification
menu
close
settings
Looker keyboard_arrow_down
language keyboard_arrow_down
English
Français
Deutsch
日本語
search
print
string_datatype

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 allows you to 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:

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

Top