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
Looker documentation will be moving to cloud.google.com in mid-2022!
All the information you rely on will be migrated and all docs.looker.com URLs will be redirected to the appropriate page.
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 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:

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